Error 'Database msdb cannot be opened' when backing up BCM

T

Tom Fountain

I received this error when attempting to backup. The message continues 'It
has been marked SUSPECT by recovery.' Then a lot of techno babble about SQL
that I don't understand. I also says that the backup/restore was still
successful, but it wasn't. I tried to restore the previous backup, but to no
avail. I'm lost on how to proceed, can anyone help? By the way, the link to
'Terms of Use' is not working.
 
L

Leonid S. Knyshov // SBS Expert

Tom,

Why are you faced with this situation? Is BCM currently working?

If BCM is working and the backup process is not working, it suggests a
corruption. I'd connect to the SQL instance and troubleshoot it from there.
This is likely to be technobabble to you so I'll skip the details.

What is the exact SQL error message?
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
 
T

Tom Fountain

Leonid
Thank you for responding.
I got the error doing a routine backup through Database Tools/ Manage
Database/ Backup database' which I have done often before without incident.
There is no error number, but the message reads:
"'Database msdb cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information. Coulld 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."
There is then some % processed information and statistics.
Note that the backup was not successful, at least I cannot see the sbb file
it in the selected location. Also I tried to restore a previous backup but
got a similar error. BCM appears to be working fine. I found the SQL log,
which I don't really understand, but it says it placed a backup in a file
location, but the location seems empty.
I can send you a screenshot of the error and a file of the log if it would
help
Regards
Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top