Replication or Logship | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication or Logship

Hi all, i have 2 SQL servers, 1 in production and a second as a backup. What would you guys suggest for failover and to lose a minimum data, Replication or Log Shipping?
Both running SQL 2005 Std SP1
To replicate you have to have PK for each table involved…and if the db is very big it not advisable… You can use log shipping…
and also you can take the help of database mirroring but in standard edition it has to be in synchronous mode which is not advisable…
Moderator All postings are provided “AS IS” with no warranties for accuracy.

so to summarize LogShip is the most appropriate choice in the case? AKTHAR
Replication is only for transferring the DB objects no the entire DB.In my opinion DB mirroring is the best solution for high availability.When compared with logshipping mirroring provides automatic failover,if u use synchronous mirroring with enterprise edition.downtime is less with mirroring when compared to logshipping Regards
I am using synchronous mirroring on 2005 Std Edition and performance is fine. It’s a lot easier than log shipping and failover is much less hassle.
agree on DB mirroring. For now i have choice only between logship and replication. AKTHAR
Then go with Logshipping [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />MohammedU.<br />Moderator<br /><br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />