April 27, 2006 at 3:58 pm
Hello everybody,
I have a backup database file on ORION Server which is on D Drive. I want to restore the back up database file to another server on C drive. However Enterprise Manager does not allow the ability to change drives on the restore backup.
Would be greatful if somebody can guide me how to restore the back up file on C drive on another server.
Thanks,
Kapil Shah
April 27, 2006 at 4:53 pm
Use T-SQL to restore the database using the 'MOVE' option. See 'How to restore files to a new location' in BOL.
Greg
Greg
April 27, 2006 at 4:54 pm
Sure it does In enterprise manager, Select your backup file, Then click the Options tab.
In the Restore Database Files As, change the path to your files as the new server requires.
Or Use T-SQl And use the with move keywords
RESTORE FILELISTONLY
FROM MyNwind_2
-- Restore the files for MyNwind2_Test.
RESTORE DATABASE MyNwind2_Test
FROM MyNwind_2
WITH RECOVERY,
MOVE 'MyNwind2_data' TO 'D:\MyData\MyNwind2_Test_data.mdf',
MOVE 'MyNwind2_log' TO 'D:\MyData\MyNwind2_Test_log.ldf'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply