March 13, 2012 at 11:38 am
I have a Sharepoint instance that is mirroring a majority of the databases. I'm implementing a weekly index reorg/rebuild job (thanks http://ola.hallengren.com) and want to put the databases into BULK_LOGGED recovery model before I perform the maintenance.
I realize that the reorgs will not take advantage of the BULK_LOGGED recovery model.
Is anyone else doing something similar? I figured my steps would look like this:
Suspend mirroring
BACKUP LOG
BULK_LOGGED recovery
Run index maintenance
FULL recovery
BACKUP LOG
Resume mirroring
I'm trying to avoid an unnecessary bloating of the t-logs. I don't have any historical data on index fragmentation.
Thoughts or suggestions?
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
March 13, 2012 at 11:53 am
Most likely won't work as database mirroring requires the use of the full recovery model.
At a previous employer where I implemented database mirroring I did not attempt to change the recover model while doing index maintenance on the HR and Finance systems. There did not appear to be any real impact on the systems with the index maintenance running at night with few (if any) users on the system.
March 13, 2012 at 12:02 pm
Good point Lynn, suspending the mirroring won't work.
Back to the drawing board.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply