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 |
|
pvsramu
Starting Member
17 Posts |
 Posted - 2010-01-28 : 23:16:20
|
| We have primary database mirrored to DR site. Will running defrag on primary database affect mirroring setup? I understand log file size grow when we run defrag. Wondering would that be of any problem for mirroring. We have synchronus mirroring configured to secondary database on DR site. |
|
|
DaleTurley
Yak Posting Veteran
76 Posts |
Posted - 2010-01-29 : 08:42:47
|
quote:
Originally posted by pvsramu
We have primary database mirrored to DR site. Will running defrag on primary database affect mirroring setup? I understand log file size grow when we run defrag. Wondering would that be of any problem for mirroring. We have synchronus mirroring configured to secondary database on DR site.
With database mirroring, anything that gets written to the TLog on the primary will get written on the mirror. Same applies here - any logged operations will get mirrored. |
 |
|
|
|
|
|
DEFRAG effect on DB Mirroring