Friday, October 9, 2009

sql server



What a backed up Database Mirror looks like
One thing you need to be careful about with sql server 2005/2008 Database Mirroring is making sure that you don't exceed the I/O capacity of the storage subsystem of the sql server instance where the mirrored database lives. If you do this with High Safety mode (synchronous) mirroring, your applications will be slowed down, waiting on the mirror. This usually happens when you do something that generates an unusual amount of log activity (such as index creation or maintenance, or shrinking a d

Blog Content

No comments:

Post a Comment