| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
04-03-2008, 09:17 PM
|
|||
|
|||
ANY dialect question:
Systems EngineerI have a question related to SQL backup jobs. I have transacton backup jobs set to run hourly from 7am to 7pm. And a full backup to run at 10pm.
Backup jobs are not set to run over the weekend and no one is making entries after 5pm on Friday. Check Integrity, and Rebuild index is running over the weekend however. My questoin is this: Why would the transaction backup at 7am on Monday be the largest back up of the week. It is noticably larger than other transaction backups. And as I mentioned no transaction had been entered.     
|
|
08-26-2008, 10:16 AM
|
|||
|
|||
|
ANY answer.
Re: Systems Engineer
The reason is due to the Integrity Check and index Rebuilding that is happening over the weekend... since the database is in FULL recovery mode, the checkpoints are less... So the transaction log backup on monday 7AM will be large...
|
