SQL 2005 Mirror Best Practice
- From: brettmanning24@xxxxxxxxx
- Date: Thu, 5 Jun 2008 03:18:17 -0700 (PDT)
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
.
- Prev by Date: RE: Is there any way to know a subscription is nearly expired?
- Next by Date: Not getting Replication Alerts
- Previous by thread: trigger problems and transactional replication
- Next by thread: Not getting Replication Alerts
- Index(es):
Relevant Pages
|
