RESTORE DATABASE with MOVE example
Posted: Wed May 24, 2006 1:58 pmrestore database Northwindrep
from disk = 'c:\northwind.bak'
with move 'Northwind' to 'c:\Northwindrep.mdf',
move 'Northwind_log' to 'c:\Northwindrep.ldf'
from disk = 'c:\northwind.bak'
with move 'Northwind' to 'c:\Northwindrep.mdf',
move 'Northwind_log' to 'c:\Northwindrep.ldf'