DB Mirroring - High Availability

Question

DB Mirroring - High Availability

Viewing 4 posts - 16 through 19 (of 19 total)

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

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Perry Whittle (10/21/2010)
bh 58161 (10/21/2010)
I know restoring it isn't how mirroring works.
Actually that's exactly how mirroring a database starts!

If he just restores the database (typical options), the 'mirror' will be restored and recovered and will be useless for mirroring and will require a re-restore. The witness doesn't need the database at all.

Before doing the backups and restores, the endpoints should be set up, the certificates configured, the logins created (with the correct SIDs), the recovery models checked and set if necessary.

Yes, configuring mirroring involves a backup/restore, but i wouldn't say it's the first thing that should be done.

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

Perry Whittle SSC Guru Points: 234065 More actions · Answer 2

Bh 58161

Forgetting endpoints, authentication and mirroring modes, database mirroring is based upon a restore of the principal database. You really need to research and understand this more before going any further

Btw it was you who stated mirroring does not involve a restore!

bh 58161 (10/21/2010)
I know restoring it isn't how mirroring works.

I have a complete script that will set up and configure mirroring but it's pointless giving it to you unless you have a thorough understanding!!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

bh 58161 SSC Rookie Points: 38 More actions · Answer 3

I have just watched a tutorial about it on the web and listened. The setup seems ok, i am testing it now and I am comfortable setting it up.

The only thing that it didnt go into was the witness instance, i assume this doesnt have to be the same instance as the principal and mirror, it can be the default instance setup when isntalling sqlexpress?

Thanks.

Perry Whittle SSC Guru Points: 234065 More actions · Answer 4

correct, you may use a SQLExpress instance for the witness server!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉