<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Honza Mensdorff
»
Mirrors
13 posts, Page 1 of 2
1
2
»»
Mirrors
Rate Topic
Display Mode
Topic Options
Author
Message
honza.mf
honza.mf
Posted Monday, December 10, 2012 10:25 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 1,103,
Visits: 1,200
Comments posted to this topic are about the item
Mirrors
See, understand, learn, try, use efficient
© Dr.Plch
Post #1394884
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Tuesday, December 11, 2012 1:35 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 8:31 AM
Points: 3,129,
Visits: 4,312
Had to dust off the cobwebs on this one
Thanks for this, always good to refresh the grey matter...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1394931
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, December 11, 2012 1:53 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
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
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1394939
honza.mf
honza.mf
Posted Tuesday, December 11, 2012 2:12 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:05 AM
Points: 1,103,
Visits: 1,200
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
Post #1394949
DugyC
DugyC
Posted Tuesday, December 11, 2012 4:47 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 3:25 AM
Points: 1,165,
Visits: 731
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.
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1395045
L' Eomot Inversé
L' Eomot Inversé
Posted Tuesday, December 11, 2012 6:02 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 11:26 AM
Points: 7,110,
Visits: 7,183
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
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1395075
Bob Cullen-434885
Bob Cullen-434885
Posted Tuesday, December 11, 2012 6:54 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:52 AM
Points: 509,
Visits: 388
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?
Post #1395099
Dana Medley
Dana Medley
Posted Tuesday, December 11, 2012 6:54 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 7:11 AM
Points: 1,356,
Visits: 874
Great question. I picked wrong like a few before me (Set up but not started), so thank you for teaching me something today.
Oh no, we're toast!
I've got this. *Keyboard clatter*
Woah, how'd you do that?
I'm a DBA...Booyah
Yeah, uh huh, you know what it is. Everything I do, I do it big
Post #1395100
pchirags
pchirags
Posted Tuesday, December 11, 2012 7:19 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 8:33 AM
Points: 1,217,
Visits: 236
Great QoTD...
got it wrong, but your explanation was nice..
learned something...
thanks...
Post #1395113
Lokesh Vij
Lokesh Vij
Posted Tuesday, December 11, 2012 9:49 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 1,176,
Visits: 1,253
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
Guidelines for answers on Performance questions
Link to my Blog Post -->
www.SQLPathy.com
Follow me
@Twitter
Post #1395210
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
