SQL Server Performance Forum – Threads Archive
Two identical SQL databasesI have two identical databases that each of them resides on different servers. One of them serves as the primary database where the users are connected to. I need to make the secondary database on the other server to be the same as the primary database. In other words, the data on both machines need to be the same up to minute. Any ideas and suggestions as how to make this happen? Thanks Bugme
Take a look of replication in Books on Line.
SQL-Server-Performance.com All in Love is Fair
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
If you want the secondary database as a warm standby and read-only until the time of restore you can take help of Log shipping. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.