Mirrors

Question

Mirrors

honza.mf

SSCertifiable

Points: 5519
More actions
December 10, 2012 at 10:25 pm

#265886

Comments posted to this topic are about the item Mirrors

See, understand, learn, try, use efficient
© Dr.Plch
December 11, 2012 at 1:35 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

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

Establish a Database Mirroring Session Using Windows Authentication (Transact-SQL)

(points 4 and 5)

Are you sure a log backup is needed? Quoting from BOL:

Typically, you need to take at least one log backup on the principal database. However, a log backup might be unnecessary, 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.

Prepare a Mirror Database for Mirroring

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

honza.mf SSCertifiable Points: 5519 More actions · Answer 2

Koen Verbeeck (12/11/2012)
Are you sure a log backup is needed? Quoting from BOL:
Typically, you need to take at least one log backup on the principal database. However, a log backup might be unnecessary, 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.
Prepare a Mirror Database for Mirroring

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.

See, understand, learn, try, use efficient
© Dr.Plch

DugyC Hall of Fame Points: 3804 More actions · Answer 3

Koen Verbeeck (12/11/2012)
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).
Establish a Database Mirroring Session Using Windows Authentication (Transact-SQL)
(points 4 and 5)
Prepare a Mirror Database for Mirroring

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.

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

TomThomson SSC Guru Points: 104773 More actions · Answer 4

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.

Tom

Dana Medley SSCertifiable Points: 6764 More actions · Answer 5

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

Everything is awesome!

Bob JH Cullen SSCrazy Points: 2082 More actions · Answer 6

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?

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 7

Great QoTD...

got it wrong, but your explanation was nice..

learned something...

thanks...

Lokesh Vij SSChampion Points: 10836 More actions · Answer 8

Same here...also got the question wrong. Thought it would set-up but not start.

Always good to learn something new 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 10

(Bob Brown)

SSCrazy

Points: 2705

December 12, 2012 at 4:26 am

#1567815

Good question. Too hard for me.

vinayverma1896 SSC Rookie Points: 42 More actions · Answer 11

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

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 12

Why error? what is wrong? Everything seems correct except the mirroring will not start because you miss the transaction log backup restored on the srv2.

Igor Micev,My blog: www.igormicev.com