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 |
|
dholland
Starting Member
11 Posts |
 Posted - 2007-12-10 : 11:51:34
|
| Hello all. I'm new to mirroring, I've used log shipping and replication previously..We are in the middle of setting up some new infrastructure. We have a SQL server, a backup SQL server, websites and other apps that access the SQL. We have plenty of machines that could have SQL express in order to be the monitor/watcher machine if we decide to do mirroring but I have a few questions...If we do maintenance (Service packs, updates, whatever) that requires us to reboot the main SQL server.. does the watcher see that and stop all activity? Does it start the process of moving primary to the backup mirror? How does that process work and what are the options.I like the idea of mirroring, but I want to make sure we can perform maintenance without having system downtime.Thank you for your time.Dave |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-10 : 22:54:17
|
| Depends on how you set db mirroring, find details in books online. |
 |
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2007-12-11 : 17:51:18
|
| Hi Dave...I have gone through the growing paing of installing and setting up database mirroring. Yes you can perform maintenance without having downtime using database mirroring. In short, you can manual cause the "fail over" from the primary server to the mirror server without down time. Then once you are done you can "fail back" from the mirror to the primary server. It takes a couple of minutes usually for database mirroring to resync. I use database mirroring in this manner. I have more information on my blog about database mirroring. You may find it here: http://www.lockergnome.com/sqlsquirrel/2007/11/28/database-mirroring-in-sql-server-2005/Cheers!Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
|
|
|
|
|
|
Some Basic Questions