SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Honza Mensdorff / Mirrors / Latest Posts

RE: Mirrors

vinayverma1896 — Wed, 12 Dec 2012 22:03:41 GMT

:-) Is not getting right answer and lot of work data layer site so can give me suggestion??

RE: Mirrors

(Bob Brown) — Wed, 12 Dec 2012 04:26:11 GMT

Good question. Too hard for me.

RE: Mirrors

SQLRNNR — Tue, 11 Dec 2012 14:26:02 GMT

Thanks for the question.

RE: Mirrors

Lokesh Vij — Tue, 11 Dec 2012 09:49:10 GMT

Same here...also got the question wrong. Thought it would set-up but not start.Always good to learn something new :-)

RE: Mirrors

pchirags — Tue, 11 Dec 2012 07:19:38 GMT

Great QoTD...got it wrong, but your explanation was nice..learned something...thanks...

RE: Mirrors

Dana Medley — Tue, 11 Dec 2012 06:54:15 GMT

Great question. I picked wrong like a few before me (Set up but not started), so thank you for teaching me something today.

RE: Mirrors

Bob Cullen-434885 — Tue, 11 Dec 2012 06:54:15 GMT

I got it right but, apparently, for the wrong reason. I looked at ALTER Db SET PARTNER = .... and thought that was illegal syntax.If it isn't, what is it actually doing, please?

RE: Mirrors

L' Eomot Inversé — Tue, 11 Dec 2012 06:02:46 GMT

Interesting question. I picked the same wrong answer (set up but not started) as 45% of those who answered before me, so I've learnt something.

RE: Mirrors

DugyC — Tue, 11 Dec 2012 04:47:43 GMT

[quote][b]Koen Verbeeck (12/11/2012)[/b][hr]I got it right, but only because I thought you had to link the mirror to the principal first, and then the principal to the mirror (which starts the mirroring session).[url=http://msdn.microsoft.com/en-us/library/ms175883.aspx]Establish a Database Mirroring Session Using Windows Authentication (Transact-SQL)[/url](points 4 and 5)[url=http://msdn.microsoft.com/en-us/library/ms189053.aspx]Prepare a Mirror Database for Mirroring[/url][/quote]Likewise, however I got this wrong, because rather than thinking it would error, I thought it would succeed but not start the mirroring... learned some useful stuff though, so all good.Thanks for the question.

RE: Mirrors

honza.mf — Tue, 11 Dec 2012 02:12:44 GMT

[quote][b]Koen Verbeeck (12/11/2012)[/b][hr]Are you sure a log backup is needed? Quoting from BOL:[quote]Typically, you need to take at least one log backup on the principal database. However, [b]a log backup might be unnecessary[/b], if the database has just been created and no log backup has been taken yet, or if the recovery model has just been changed from SIMPLE to FULL.[/quote][url=http://msdn.microsoft.com/en-us/library/ms189053.aspx]Prepare a Mirror Database for Mirroring[/url][/quote]I'm quite sure. The procedure in the question is the same I used to establish the mirror, I tried both wizard and T-SQL. The database was just changed from simple to full recovery model.I repeated the test when writing the QotD, with the same result. There was only one difference: First time the error message was completely confusing, but this was not reproduced.

RE: Mirrors

Koen Verbeeck — Tue, 11 Dec 2012 01:53:43 GMT

I got it right, but only because I thought you had to link the mirror to the principal first, and then the principal to the mirror (which starts the mirroring session).[url=http://msdn.microsoft.com/en-us/library/ms175883.aspx]Establish a Database Mirroring Session Using Windows Authentication (Transact-SQL)[/url](points 4 and 5)Are you sure a log backup is needed? Quoting from BOL:[quote]Typically, you need to take at least one log backup on the principal database. However, [b]a log backup might be unnecessary[/b], if the database has just been created and no log backup has been taken yet, or if the recovery model has just been changed from SIMPLE to FULL.[/quote][url=http://msdn.microsoft.com/en-us/library/ms189053.aspx]Prepare a Mirror Database for Mirroring[/url]

RE: Mirrors

Stewart "Arturius" Campbell — Tue, 11 Dec 2012 01:35:35 GMT

Had to dust off the cobwebs on this oneThanks for this, always good to refresh the grey matter...

Mirrors

honza.mf — Mon, 10 Dec 2012 22:25:50 GMT

Comments posted to this topic are about the item [B]Mirrors[/B]