July 31, 2011 at 4:46 pm
Hi,
i have one production server and one is DR server my Production server having some problem and i want to
restore DB backup from DR server
Problem: my problem is DB size is huge and i dont have extra hard drive on production server.
now i want to directly restore DB on network
i am confuse ho to map my DR server drive on production server ????? is there any other way to do the
same job ????
Please help me i will thank all of you
Regards
Syed
July 31, 2011 at 9:00 pm
Make sure the service account running SQL Server has access to the network share, then use the UNC path to access the backup files.
Be aware that backing up or restoring across the network will take longer than doing this locally and may fail with network related errors if you do not have a very stable network infrastructure in place to handle this.
Here is an example:
RESTORE DATABASE MyDatabase
FROM DISK = '\\myDRServer\MyBackupFolder\MyDatabase_backup.bak'
WITH REPLACE, {other options as needed};
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 31, 2011 at 11:51 pm
Hi,
Thanks for your reply.
can i do the same job via management Studio ???
Regards
Syed
August 1, 2011 at 9:30 am
yes. I don't think you can browse to a UNC path, but you can paste it in.
August 1, 2011 at 9:47 am
homebrew01 (8/1/2011)
yes. I don't think you can browse to a UNC path, but you can paste it in.
Yup, what I usually do is build the restore command from SSMS GUI, then hit the script button and then edit the path in.
I'm doing this type of server to server restore to confirm the backups and run checkdb and it works fine!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply