mirroring in sqlserver2k5

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).

more ▼

asked Dec 08 '09 at 05:57 AM in Default

kaka gravatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
more ▼

answered Dec 08 '09 at 06:41 AM

David Wimbush gravatar image

David Wimbush
4.7k 28 29 31

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Dec 08 '09 at 04:55 PM

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 76 79 82

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 08 '09 at 05:57 AM

Seen: 627 times

Last Updated: Dec 08 '09 at 05:57 AM