SQL 2005 Mirroring is difficult to setup, you would face a lot of error message if you follow the document supplied by MS. This tutorial is a summary of many hours of try and error and a lot of reading in forums. Hope you can setup SQL 2005...More
SQL 2005 Mirroring is difficult to setup, you would face a lot of error message if you follow the document supplied by MS. This tutorial is a summary of many hours of try and error and a lot of reading in forums. Hope you can setup SQL 2005 Mirroring
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<br/>9004,00.html
-
Get Site Info
One nice feature of SQL Server that is used quite a bit is the use of identity columns. This function gives you a simple way of creating a unique value for every row in your table. Adding a new column and making it an identity column is a...