Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.
View Answer
| May 7 2008 4:12 PM GMT
| asked by
SQL Server Ask the Experts
Database mirroring, SQL Server 2005, SQL Server alerts
Problem occuring while performing Mirroring
Hi,I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers2. Created a new database named it as FinalMirror3. Right clicked on the database Tasks-backup-BackupType--Full--Ok created FinalMirror.bak4. ...
View Answer
| Apr 1 2008 11:46 AM GMT
| asked by
Cmrhema
SQL Server, SQL Server 2005, Database mirroring
Setting up database mirroring for disaster recovery in SQL Server
I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, how do I make sure...
View Answer
| Mar 11 2008 10:04 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, Disaster Recovery, High Availability (HA)
