2 SQL 2000 Server - daily replcation 1

[Simonchtan]

Hi,

Any1 knows how to config 2 sql server to do daily replication over 2 IP Network Subnet.

Server A is to "so call Backup" a Live and running Database to the Server B without any disruption to the database.

I read something on the publishing and distrubtion but gotten some General Error instead.

Hope someone can help..

thanks


I know no voice, I knew not systems,
i know NUTS on networking, Therefore I dont know anything!
------------------------------------
©2003,2004 SCHT.

 

[JayKusch]

Have you looked into Log Shipping?

Thanks

J. Kusch

 

[Simonchtan]

I'm sorry but could you show what exactly is Log Shipping
I'm not train in SQL or any form of DB. I just happen to bump into this area of Responsibility

I know no voice, I knew not systems,
i know NUTS on networking, Therefore I dont know anything!
------------------------------------
©2003,2004 SCHT.

 

[JayKusch]

Essentially, log shipping is the process of automating the backup of database and transaction log files on a production SQL server, and then restoring them onto a standby server. But this is not all. The key feature of log shipping is that is will automatically backup transaction logs throughout the day (for whatever interval you specify) and automatically restore them on the standby server. This in effect keeps the two SQL Servers in "synch". Should the production server fail, all you have to do is point the users to the new server, and you are all set. Well, its not really that easy, but it comes close if you put enough effort into your log shipping setup.

Here is the article I pulled it from. Shows how to configure log shipping too!

http://www.sql-server-performance.com/sql_server_log_shipping.asp

Thanks

J. Kusch

 

[Simonchtan]

wow... thanks... i will need some time to crush this down...

I know no voice, I knew not systems,
i know NUTS on networking, Therefore I dont know anything!
------------------------------------
©2003,2004 SCHT.