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
AKTHAR

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…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

so to summarize LogShip is the most appropriate choice in the case? AKTHAR

Hi,
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
Deepak
SQL DBA

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=’

‘ />] MohammedU. Moderator SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

thks AKTHAR

]]>