HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.replication » SQL 2005 Mirror Best Practice

Topic: SQL 2005 Mirror Best Practice

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 6/7/2008 1:19:02 PM

By:

Hello,

I am just looking for some advices on best practices on SQL 2005
mirroring. I have mirrored a database using SQL 2005. I have a
principal and a mirror server. My question is regarding the best way
to tackle a complete failure of the principal server (i.e. server
failure). Automatic failover is not in place, any failover would be
manual.

Does this sound like a reasonable plan of action assuming the
principal server is offline:

Promote the Mirror to Principle using:

ALTER DATABASE DBNAME SET PARTNER OFF
RESTORE DATABASE DBNAME WITH RECOVERY

The mirror should now act as the principle.

If I am able to recover the old principal server would the best plan
of action be:

Backup the current principal
Restore the backup to the old principal with no recovery i.e. act as
mirror
Start the Mirror then manually failover so the old principal becomes
the principal.

Does this sound acceptable?

Thanks,

Brett

Replies below ↓