Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2007-11-07 : 09:16:55
|
| Can anyone please tell me what mirroring is??Thanks in ADvanceRKNAIR |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-07 : 09:19:41
|
you can read a lot about it in BOL... quote:
Database mirroring can be used in conjunction with replication to provide availability for the publication database. Database mirroring involves two copies of a single database that typically reside on different computers. At any given time, only one copy of the database is currently available to clients. This copy is known as the principal database. Updates made by clients to the principal database are applied on the other copy of the database, known as the mirror database. Mirroring involves applying the transaction log from every insertion, update, or deletion made on the principal database onto the mirror database.
Em |
 |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-07 : 09:19:57
|
| here is the web entry for sql 2005 books online, it is an excellent reference if you have not installed it YET...http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx...In database mirroring, an originating SQL Server 2005 instance continuously sends a database's transaction log records to a copy of the database on another standby SQL Server instance. The originating database and server have the role of principal, and the receiving database and server have the role of mirror. The principal and mirror servers must be separate instances of SQL Server 2005.... |
|
|
|
|
|
|
Mirroring