August 12, 2009 at 8:12 am
I am trying to backup a log with the statement :
BACKUP LOG test TO DISK = 'C:\1.bak' WITH NO_TRUNCATE, INIT
I am getting the below error. msdbdata.mdf file is full.
Msg 3009, Level 16, State 1, Line 1
Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.
What to do. How to free msdb database ?
August 12, 2009 at 8:51 am
Whenever any backup is taken then msdb..backupset table is updated. Just see whether the data files for msdb is set for autogrowth. Verify the %Free space for the disk drive where msdb files are located.
-LK
August 12, 2009 at 8:56 am
Have a look at tables in msdb to see if any are exceptionally large...especially if you have been running DTA on this server, it is possible that msdb has grown very large.
August 12, 2009 at 9:02 am
As the poster above mentioned, often those errors are flagged as SQL is trying to write to the particular database and has insufficient disk space to write even one additional row.
msdb may not be the issue at all, rather the drive space where your msdb resides...
August 12, 2009 at 9:07 am
I think you are quite correct.
How msdb is affected when DTA is run, David?
-LK
August 13, 2009 at 5:47 am
The history of Tuning Advisor executions is stored in the DTA_ tables.
I have seen MSDB grow beyond 10Gb with much DTA activity...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply