I have setup a log shipping pair and they were working until Sunday morning every week (2 weeks in a row). I found that there is only job was running at 2am Sunday morning. I think this weekly maintenance job is the culprit. The steps of the jobs are: Step Name: Steps: Simple Recovery ALTER DATABASE PwhcProd01 SET RECOVERY SIMPLE DBCC DBREINDEX sp_MSforeachtable 'DBCC DBREINDEX(''?'') WITH NO_INFOMSGS' DBCC UPDATEUSAGE DBCC UPDATEUSAGE ('Database1') WITH NO_INFOMSGS DBCC FREEPROCCACHE DBCC FREEPROCCACHE DBCC CHECKCATALOG DBCC CHECKCATALOG ('Database1') WITH NO_INFOMSGS DBCC CHECKCONSTRAINTS DBCC CHECKCONSTRAINTS WITH ALL_CONSTRAINTS, NO_INFOMSGS DBCC CHECKDB DBCC CHECKDB ('Database1') WITH NO_INFOMSGS Update Statistics sp_updatestats Set to Full Recovery ALTER DATABASE PwhcProd01 SET RECOVERY FULL During this weekly maintenance job running, the logshipping is not running. Now I have the following questions: 1. What are the steps may cause the log shipping out of sync (not workiing)? 2. May I have the log shipping continue to run while the performing DB maintenance? 3. Not setting the DB to simple mode will make the DB maintenance run longer and create BIG log file. Any suggestions? 4. What's the best practice for running log shipping and long running DB maintenance? Your help will be highly appreciated.