Solved

Could not insert a backup or restore history/detail record on msdb.dbo

Posted on 1998-07-21
1
1,434 Views
Last Modified: 2009-07-29
I get this error message when I do a backup to tape. Prior to the backup I clear the translog which is full.

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

How I can solve this problem? Thanks.
0
Comment
Question by:kvseng
1 Comment
 
LVL 1

Accepted Solution

by:
baryonic earned 200 total points
ID: 1091814
Have you tried querying on sysbackuphistory?
This keeps a record of all backups. If you cannot select entries from this table in msdb, is it because it says table does not exist (in which case, does the table exist with a different owner to dbo - check in sysobjects for msdb).
Could your msdb database be full?
You may need to clear down old history records.
In Enterprise Manager, in Manage Scheduled Tasks, look at Task Engine Options to see if you have a limit on Task History Log.
If there is no limit, this could explain why database has filled up (if it has).
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Calculate values in an array 18 35
SQL Login 17 40
how can i make refactoring for below code for making faster? 4 29
SSRS troubles 4 20
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now