| Author |
Topic |
|
daunce
Starting Member
11 Posts |
 Posted - 2008-08-21 : 16:20:56
|
| Hi All.I'm a bit confused on the terms, and they all seem to mix together, so would someone be able to clarify the following terms:mirroringreplication (peer to peer transaction)To me, at the end of the day there's another copy of the db, so they appear to be the same.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-21 : 16:25:01
|
quote:
Originally posted by daunce
Hi All.I'm a bit confused on the terms, and they all seem to mix together, so would someone be able to clarify the following terms:mirroring -- Its a high availability option.You won't be able to access secondary database(Norecovery Mode)replication (peer to peer transaction)--You will able to access and run in secondary database.To me, at the end of the day there's another copy of the db, so they appear to be the same.Thanks
|
 |
|
|
daunce
Starting Member
11 Posts |
Posted - 2008-08-21 : 19:13:10
|
| ahh.. ok.. And how does log shipping differ from peer to peer transaction replication? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-21 : 19:22:36
|
quote:
Originally posted by daunce
ahh.. ok.. And how does log shipping differ from peer to peer transaction replication?
Log shipping ships the log from primary server to secondary server.Secondary database can be in Read/only mode or Norecovery mode. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-21 : 19:23:34
|
| It's another high availability solution where you can choose to either have the secondary database in read-only mode or in norecovery mode. Each time a tlog backup is restored, it'll need to kick out the users if you chose the read-only mode.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
daunce
Starting Member
11 Posts |
Posted - 2008-08-21 : 19:32:11
|
| woah.. so fast on the replies! you are both awesome!ok, so now mirroring and log shipping seem to be the same.. how are they different?both end up having a copy on another server, mirror has no access to second db, and same with log shipping unless in read only mode. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-21 : 19:37:54
|
| Mirroring is lower level. Log shipping happens with transaction log backups. Mirroring uses the transaction log and can be sync or async. With mirroring you can have automatic failover.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
daunce
Starting Member
11 Posts |
Posted - 2008-08-21 : 20:01:40
|
| Thanks for clarifying that for me. much appreciated. |
|
|
|
|
Clarification of terms.