I have a Sql job that runs every Tues and Fri at 1:05 AM and does the following.
- Set recovery to Bulk
- DBCC DBREINDEX
- DBCC UPDATEUSAGE
- DBCC CHECKCATALOG
- DBCC CHECHCONSTRAINTS
- DBCC CHECKDB
- sp_MSforeachtable UPDATE STATISTICS ? WITH FULLSCAN
- Set Recovery FULL
The logshipping restore database is in another facility connected to a 6mb network.
For some reason the restore will not run after 1:00 am on these days.
Is this because on the Bulk Recovery change?
Thanks in advance