<div>
<div class="content wysiwyg-content">
Hi Again<br />
<br />
Can anyone tell me if there are any housekeeping tasks that should not be performed when mirroring and / or log shipping?<br />
<br />
I am currently running (on the principle);<br />
<br />
Check db integrity,<br />
Rebuild Index<br />
Reorganise Index <br />
Update statistics<br />
<br />
Along with a full back up and the various clean up tasks. <br />
<br />
I am not seeing any issues as such at the moment, but have seen a number of people reporting that rebuilding and reorganising indexes can break log shipping - are we currently being lucky?<br />
<br />
Your thoughts, as always, are greatfully received.<br />
<br />
Sue
</div>
</div>


Hi Again

Can anyone tell me if there are any housekeeping tasks that should not be performed when mirroring and / or log shipping?

I am currently running (on the principle);

Check db integrity,
Rebuild Index
Reorganise Index 
Update statistics

Along with a full back up and the various clean up tasks. 

I am not seeing any issues as such at the moment, but have seen a number of people reporting that rebuilding and reorganising indexes can break log shipping - are we currently being lucky?

Your thoughts, as always, are greatfully received.

Sue

Housekeeping tasks when mirroring and log shipping

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.