If you are getting the WITH MOVE error in a sql 2005 restore you can do the following.
[sql]
RESTORE FILELISTONLY FROM DISK = 'F:\BackUp\YourBaackUpFile.bak'
GO
Step 2: Use the values in the LogicalName Column in following Step.
--Restore Database
RESTORE DATABASE YourDB
FROM DISK = 'F:\BackUp\YourBaackUpFile.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:DataYourMDFFile.mdf',
MOVE 'YourLDFLogicalName' TO 'D:DataYourLDFFile.mdf'
GO
[/sql]
|