I have configured Database Mirroring successfully between 2 SQL Server 2005 instances. My application is connecting to SQL Server using a SQL Server login, and is built using ODBC and the SQL Native Client. My connection strings/connection settings specify the correct information, including the appropriate...

I have a mirrored sql 2005 server and it was in suspended mode .I Removed the mirroring from the primary server.Now the mirror db shows as mirror disconnected recovery status .How can I MAKE THIS DB to normal mode .so that i can configure the mirroring again THANKS

I came to know that one of the server that was mirrored was suspended .I tried to resume mirroring by clicking the resume button and nothing happens on the screen .The db still in suspended mode .HOW TO FIND THE REASON FOR THE FAILURE .Is is due to transaction logs ?The logs are growing now and we have...

Hi, We have one of the databases on SQL Server 2005 Enterprise edition. Its around 500 GB and is configured for mirroring as well as log shipping.Mirroring is configured through SQL Server database properties where as log shipping is happening through a 3rd party tool by redgate called SQL Backup.There...

Hi, You have to perform failover manually, refer Log Shpping,failover in BOL for more information and steps If you have replication setup on primary server and if primary server fails, replication won't continue refer http://msdn2.microsoft.com/en-us/library/ms151224.aspx and it is suggested to use...