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 BugmeTake a look of replication in Books on Line.
Luis Martin
Moderator
SQL-Server-Performance.com 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
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>