August 17, 2005 at 9:39 am
Hi all,
I am trying to access the database backup file from different server.
because it take lots of time to do the copy the back up and restore so want to restore database on test server directly from back up on prod servet. is this command right cuz it is not working?
RESTORE DATABASE Testdb
FROM '//prodserver\G:\backupfolder\backupfile'
WITH NORECOVERY,
MOVE 'testdb_data' TO 'D:\MyData\testdb_data.mdf',
MOVE 'testdb_Log' TO 'D:\MyData\testdb_Log.ldf'
August 17, 2005 at 9:53 am
The FROM command has forward slashes instead of backslashes.
Keep in mind the server is sensitive to network issues, so this might fail. A copy is probably worth the time since you could easily try this 2-3 times if the network hiccups.
August 17, 2005 at 11:01 am
it somehow doesnot work is there other command through query analyzer that can work?
thanks
August 18, 2005 at 11:43 am
also besides the forward slashes in the "FROM" clause ... "G:" (G colon) is not correct. A colon is not part of a valid UNC name either. If you are doing this as a local admin (best on both computers) then use "G$". However the network issues are going to definitely 'bite' you.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 30, 2005 at 12:38 pm
Another thing for speed - on a MS LAN it is significantly faster to map a drive letter to where you are copying from and copy via that (i.e NOT \\server\share\filename.bak but M:\filename.bak where M: is mapped to \\server\share) - this seems to be due to re-authentication occuring with UNC's during the copy.
Also using trusty old xcopy is much faster than a straight drag n' drop in explorer
I would probably write a little .bat file and xp_cmdshell it
James Horsley
Workflow Consulting Limited
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply