HI , all I'm new to sqlserver someone plz tell me what actually happens behind the scenes during mirroring.What actions takeplace while mirroring and how it happens.
Like for replication(backup and restorations happen).
asked Dec 08, 2009 at 05:57 AM in Default
You can read all about it here: http://msdn.microsoft.com/en-us/library/ee523927.aspx
answered Dec 08, 2009 at 06:41 AM
Replication does not use backup and restore. It send transactions across from one server to another, but on an article by article basis. It reads the log and moves those across. Mirroring essentially moves all log changes, including maintenance activities, across from one database to another.
The initial setup in either case can be from a backup and restore, but that is not required in replication. The link by Davis is a great one for learning about mirroring. I might also suggest this one from Paul Randal: http://technet.microsoft.com/en-us/library/cc917680.aspx
answered Dec 08, 2009 at 04:55 PM
Steve Jones - Editor ♦♦