Two identical SQL databases | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Two identical SQL databases

I 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.
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
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.