Register   |   Login   |   February 08, 2012    |   Knowledge Base  >  Knowledge Base Systems  >  MSSQL  >  WITH MOVE error on sql restore.
search:     

Phone: 480-722-1227
Toll Free: 888-722-1227

WITH MOVE error on sql restore.
Last Post 31 May 2007 05:51 PM by Chris Muench. 0 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Chris MuenchUser is Offline
New Member
New Member
Posts:57

--
31 May 2007 05:51 PM  
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]

You are not authorized to post a reply.

Active Forums 4.2
Copyright 2006 - 2011 Vigilant Support   |  Privacy Statement  |  Terms Of Use