Database mirroring can increase the availability of SQL Server 2005 databases by copying transaction log information to a standby server, and allowing for quick failover to the standby server if the production server fails.
technet.microsoft.com/en-us/library/cc917680.aspx
-
Get Site Info
SQL Server 2005 database mirroring allows you to automatically mirror database contents. Get steps for database mirroring quick setup via Management Studio.
searchsqlserver.techtarget.com/tip/0,289483,sid87_gci119 9004,00.html
-
Get Site Info
To establish a database mirroring session and to modify the properties of database mirroring for a database, use the Mirroring page of the Database Properties dialog box.
msdn.microsoft.com/en-us/library/ms188712.aspx
-
Get Site Info
The mirror database must exist before a database mirroring session can begin. The name of the mirror database must be the same as the name of the principal database. The database owner or system administrator can create the mirror database...
msdn.microsoft.com/en-us/library/ms189047.aspx
-
Get Site Info
Database Mirroring was released with SQL Server 2005 and is becoming a popular choice for a failover solution. One of the big issues with Database Mirroring is that the failover is tied to one database, so if there is a database failure th...
This example shows all the stages required to create a database mirroring session with a witness using certificate-based authentication. The examples in this topic use Transact-SQL. Unless you can guarantee that your network is secure, we r...
msdn.microsoft.com/en-us/library/ms191140.aspx
-
Get Site Info
This will be the first of a multi-part series covering SQL Server 2005 Database Mirroring and Window...
blogs.technet.com/wbaer/archive/2007/0 4/23/sql-server-2005-database-mirrorin g-and-windows-sharepoint-services-3-0- microsoft-office-sharepoint-server-200 7-part-1-introduction-overview-and-bas ics.aspx
-
Get Site Info