May 19, 2003 at 12:36 pm
I have 2 nightly jobs which create a full backup of master and msdb. On Friday I noticed that the size of these backups was approaching ~900Mb each. They seemed to have continued to have grown over the weekend.
Both these database are tiny (< 30Mb). Does anyone know what could be causing the huge backups?
Thanks
May 19, 2003 at 9:20 pm
How large are the transaction logs for each of those databases?
The following excerpt from BOL may apply:
Note During a full database or differential backup, Microsoft® SQL Server™ backs up enough of the transaction log to produce a consistent database for when the database is restored. Only a full database backup can be performed on the master database.
Is the backup being issued with INIT? If not, each backup is appending to the previous backups. Even if INIT is specified, the following excerpt from BOL may apply:
The backup media is not overwritten if any one of the following conditions is met:
All backup sets on the media have not yet expired. For more information, see the EXPIREDATE and RETAINDAYS options.
The backup set name given in the BACKUP statement, if provided, does not match the name on the backup media. For more information, see the NAME clause.
Use the SKIP option to override these checks. For more information about interactions when using SKIP, NOSKIP, INIT, and NOINIT, see the Remarks section.
David R Buckingham, MCDBA,MCSA,MCP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply