Database Mirroring

Question

Database Mirroring

June 27, 2011 at 1:08 am

This was removed by the editor as SPAM

Viewing 10 posts - 16 through 24 (of 24 total)

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

db4breakfast Ten Centuries Points: 1097 More actions · Answer 1

Well, I just joined SSC, and answered first question correct. It's a basic question, but I notice only about 57% people got this right. So, it's not easy for some people. Thanks for the question.

--------------------------------------------------------------------------------------
Hai Ton
My Db4Breakfast blog.

Abi Chapagai SSCrazy Points: 2666 More actions · Answer 2

Abi Chapagai

SSCrazy

Points: 2666

June 24, 2011 at 1:36 pm

#1343904

Gail,

Easy and straight forward question.

Thanks,

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

SQLRNNR (6/24/2011)
I don't get it? Are you sure about that?

What are you not sure about?

I didn't pick the points, I think I'd have made this 1 point and it's partner question (which I think is scheduled for next week) worth 2.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

tnk7200 (6/24/2011)
Well, I just joined SSC, and answered first question correct. It's a basic question, but I notice only about 57% people got this right. So, it's not easy for some people. Thanks for the question.

Probably because they're getting mirroring mixed up with log shipping. Log shipping works in full and bulk-logged, database mirroring only works in full recovery.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

GilaMonster (6/24/2011)
SQLRNNR (6/24/2011)
I don't get it? Are you sure about that?
What are you not sure about?
I didn't pick the points, I think I'd have made this 1 point and it's partner question (which I think is scheduled for next week) worth 2.

Bait worked. all sarcasm

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

😛

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dhruvesh Shah SSCrazy Points: 2303 More actions · Answer 7

Knew about database mirroring.

Didn't know that log recovery works with both modes. thanks.

Peter Trast SSCarpal Tunnel Points: 4392 More actions · Answer 8

Thanks for the easy question. 🙂

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems

Trey Staker SSCarpal Tunnel Points: 4796 More actions · Answer 9

Thanks for the non-trick question. I've noticed the past month or so that there haven't been the usual "Trick" questions.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum