Viewing post 1 (of 2 total)
Try this:
USE MASTER
BACKUP DATABASE Northwind
TO DISK = 'd:\backup\Northwind.bak'
RESTORE DATABASE TestDB
FROM DISK = 'd:\backup\Northwind.bak'
WITH MOVE 'Northwind' TO 'd:\test\testdb.mdf',
...
February 26, 2002 at 2:23 pm
#424523