September 11, 2009 at 7:00 am
How to schedule backup of SQL database from one to another machine?
For e.g. in following case from source to destination machine located in different location or offices(not in LAN)
Source machine-
Windows server 2003
SQL server 2005
Destination machine
Windows server 2003
SQL server 2005
September 11, 2009 at 7:20 am
If you search this forum or Google/Bing, you will find no end of sob stories where people have tried to backup over a network, only to have it fail. The failures have show varying symptoms, but boil down to one thing... a break in the connection, even on seemingly rock solid lans.
I would highly reccommend that you backup to disk locally, and then move the backup file to its final destination using any method you choose. Without knowing a bit more about possible connections between your 2 offices, I can't make suggestions for this final bit.
September 11, 2009 at 8:35 am
There is a trace flag you can use, so you can backup to network. But it not good practise and you will enounter continual I/O and potential data loss issues. Far better as mentioned to backup to local server and copy over the network from there.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 11, 2009 at 2:03 pm
he dont need to use trace flag. it is possible to add network backup device and then backup to it. you can add this backup device from UI or by using sp_addumpdevice.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply