March 20, 2007 at 2:38 pm
Hi All,
i have a live MS SQL server with a database in it which stores the required information, i have a another server with same database structure and content.
Is there in way can make both the databases to synchronize.
Live time will be great and time based will be ok.
All help appreciated.
Thanx
March 20, 2007 at 2:41 pm
Hi Ramandeep,
You probably want to look into log shipping or some form of replication depending on your needs. Have a look in BOL.
- James
--
James Moore
Red Gate Software Ltd
March 20, 2007 at 2:51 pm
Hi James,
Thanx for your reply, would appreciate link to any tutorial or article giving more details about it.
Regards
Raman
March 20, 2007 at 3:05 pm
Hi Raman,
Brad has a nice explaination of Log Shipping over on SQL Server Performance: http://www.sql-server-performance.com/sql_server_log_shipping.asp - Several 3rd party backup tools will also help you with this, for example Red Gate's SQL Backup has a log shipping wizard availible. I think there is also one in SSMS.
On the replication front there is a fairly hefty look at replication in SQL Server 2000 on SQL Server Central.com here: http://www.sqlservercentral.com/columnists/mkodli/sql2000replicationarchitecture.asp
Hope this points you in the right direction.
- James
--
James Moore
Red Gate Software Ltd
March 22, 2007 at 12:35 pm
Hi Thanx for that, they are really informative.
Just a expert suggestion required from you experts
I have 2 databases in SQL server 2000
First database is the main and the second one needs to be exact copy of the first one.
and we need to run our application from the second one so that main is not effected in any case.
What is the best possible and the most reliable way to synchronize the both database in realtime.
Thanx very much!
March 22, 2007 at 11:52 pm
Well in this scenario you can as well us the snapshot replication or transactional replication depending on your business requirements.
In this scenarion you can make the publisher- Distributor and the subscriber to be the same instance
Or
You can set up few jobs to transfer the data across
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply