Message 3009 - Could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphisto

[Rajan]

Hi,

While backing up our database, I am getting the following message:

Could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate a problem with the MSDB database. DUMP/LOAD was still successful. (Message 3009)

Does anybody have any resolution for the same ?

Thanks,
Rajan

[Ray Miao]

Is msdb full?


------------
Rajan at 10/1/01 1:05:50 PM

Hi,

While backing up our database, I am getting the following message:

Could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate a problem with the MSDB database. DUMP/LOAD was still successful. (Message 3009)

Does anybody have any resolution for the same ?

Thanks,
Rajan

[Juergen Leis]

DUMP TRAN msdb WITH NO_LOG
DUMP DATABASE msdb TO ...

------------
Rajan at 10/1/01 1:05:50 PM

Hi,

While backing up our database, I am getting the following message:

Could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate a problem with the MSDB database. DUMP/LOAD was still successful. (Message 3009)

Does anybody have any resolution for the same ?

Thanks,
Rajan