Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
the1gadget
Yak Posting Veteran
55 Posts |
 Posted - 2008-12-02 : 09:51:46
|
| Hi AllNot sure if this is the right forum. However I will ask and I can always move it.What I have is an internal application that populates a database during working hours. This database (well a subset) needs to be copied out to two webservers. This is to happen once a day.One web server is 'live' with the other being a warm backup. FYI our internet connection is poor and it can take up to 3 hours to do a full replication. Which is to long for an international multi lingual website.What do you all suggest? Thanks-- David |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-02 : 10:08:06
|
| what about having backup restore each night? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 10:37:07
|
| Then network bandwidth has to be good if 1 webserver needs to be live. |
|
|
|
the1gadget
Yak Posting Veteran
55 Posts |
Posted - 2008-12-03 : 05:50:00
|
Hi visakh16I have tried nightly backups but run into the problem of not being able to restore to a database that is in use. This is after taking the website off line first. |
|
|
|
the1gadget
Yak Posting Veteran
55 Posts |
Posted - 2008-12-03 : 05:51:28
|
| Hi sodeepIt it the connection out of the office to the internet not the web server to the internet that it slow.-- David |
|
|
|
|
|
|
Copy a database