Solved

Housekeeping tasks when mirroring and log shipping

Posted on 2013-01-29
1
296 Views
Last Modified: 2013-02-13
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
0
Comment
Question by:rdbconcepts
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 375 total points
ID: 38833558
yes, you are currently being lucky.. :)
Reindex\mains on secondary DB-- should not ..

as long your transactions, fast network, CPU\Memory  and free space under control: seems it is OK in your case : good job!



 just in case:

Logship a large transaction log due to reindexing
http://www.sql-server-performance.com/forum/threads/logship-a-large-transaction-log-due-to-reindexing.23309/

Reindexing Job with Log Shipping configuration
http://social.msdn.microsoft.com/Forums/ta/sqldisasterrecovery/thread/03fa4a98-e668-4612-aaac-a55658fa017b
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SqlServer no dupes 25 35
Help creating a spatial object in SQL Server 4 23
abs operation in sql server 15 15
SQL Select to Group and Filter Data 5 13
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question