Database Mirroring Role Change

Role Change in Mirroring :

Database mirroring failover is an issue that can be considered from the standpoint of the database mirroring servers or the application. From the standpoint of the database mirroring servers, failover is the conversion of the mirror server into a principal server and the use of the newly recovered database as the principal database in the session. The failover may be automatic, manual, or forced.

Continue reading “Database Mirroring Role Change”

Upgrading to SQL Server 2005

Introduction:

As we all know that Microsoft has released SQL Server 2005 sometime back and is planning to release the next version KATMAI before end of 2008. Also it has announced the end of life cycle support for SQL Server 2000. Its high time that we start with upgrading our instances with SQL Server 2005 and upgrade before the life cycles support ends.

Continue reading “Upgrading to SQL Server 2005”