Please Help !!!. How to set a backup sql server
-
ie, i have got a running live sql server. Now i have installed sql server on one more system in my LAN. I want this new server to be a realtime backup of my live server. so that i can switch when ever there s a problem. wots the easiest way. and would be great if only datas(records are backed not the entire settings of the live server).
-
ie, i have got a running live sql server. Now i have installed sql server on one more system in my LAN. I want this new server to be a realtime backup of my live server. so that i can switch when ever there s a problem. wots the easiest way. and would be great if only datas(records are backed not the entire settings of the live server).
sanomni wrote: wots the easiest way Replication - though it certainly ain't easy, it will give you the ability to have real-time two-way synchronisation.... Can be a bit of a beast to set up though...have a document lying around if you're interested. "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox