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 |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2012-04-20 : 03:46:15
|
| Hi I have a 2 TB Size of Database in SQL Server 2005. Now i want to configure a Mirroring in our environment. how to synchronize the principle and mirror database. still the principle database is live.--Ragu |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
raguyazhin
Posting Yak Master
105 Posts |
Posted - 2012-04-20 : 23:57:20
|
quote:
Originally posted by robvolk
You can find detailed instructions here:http://technet.microsoft.com/en-us/library/ms189047.aspxhttp://msdn.microsoft.com/en-us/library/ms189053.aspxThese entries can also be found in your local copy of Books Online.
When I am restoring Log Backups in Mirror Database is taking 30 mins. so that time how do we restore the principle database transactions to the mirror database. because the principle database is Large OLTP Database.--Ragu |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-04-21 : 06:55:22
|
| 30 minutes is not a problem. If you want you can make and restore additional log backups to the mirror server, as long as they are restored in sequence. Make sure to specify WITH NORECOVERY on each restore, and once the last backup is restored you use ALTER DATABASE ... SET PARTNER on the mirror, then the principal. That will finalize the configuration and start mirror synchronization. |
|
|
|
|
|
|
Database Mirroring synchronization.