Video Screencast Help

Database Maintenance Failing

Created: 18 Mar 2013 • Updated: 18 Mar 2013 | 4 comments

So pretty much every morning, I get the error and event ID 57348:

Backup Exec Alert: Database Maintenance Failure

(Server: "SMIP02") (Job: "Database Maintenance") Summary of database maintenance activity:

 

Maintenance has failed: 10, Dump database failed

Total elapsed time: 00:00:03

For more information, click the following link:

http://eventlookup.veritas.com/eventlookup/EventLo...

I've tried the whole going into BEUtility that I found on the Symantec support pages. The dump database always fails and everything else like repairing the database, etc. succeeds. The database *was* originally running under a domain administrator account, bu I have changed that to a Local System startup.

Also, it seems to be looking for the msdb database in a location which has never had a drive (D:) as evidenced by some of the following events.

Event ID: 8355

 

Server-level event notifications can not be delivered. Either Service Broker is disabled in msdb, or msdsb failed to start. Event notifications in other databases could be affected as well. Bring msdb online, or enable Service Broker.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event ID: 17207

 

FCB::Open: Operating system error 3(The system cannot find the path specified.) occurred while creating or opening file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'. Diagnose and correct the operating system error, and retry the operation.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event ID: 17204

 

FCB::Open failed: Could not open file D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf for file number 1. OS error: 3(The system cannot find the path specified.).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Event ID: 17207

 

FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I am not a DB person by any stretch, so I really am not even sure where to begin looking for solutions, and doing searches online for those errors keeps bringing me back to the same solutions which I've tried and don't help.

Operating Systems:

Comments 4 CommentsJump to latest comment

CraigV's picture

Hi,

 

Nobody answered on this, but check the links below:

http://www.symantec.com/business/support/index?pag...

http://www.symantec.com/business/support/index?pag...

http://www.symantec.com/business/support/index?pag...

The general message behind them is to make sure the SQL service is running on a local service account...

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

jacksonb's picture

I had found all of those links on my own, actually. However, none of them turned out to be the problem. So this is still an issue.

VJware's picture

If you are sure that there was never ever a D: drive,then this error is really strange. Stranger is the fact, that the SQL service is running fine & backups are running fine too.

Try using SQL management studio to point the MSDBData dB's location to the correct location. Restart the SQL services & retry a database dump.

tonasis's picture

Hi Jacksonb

 

I too have the same issue, which has just started happening, and have gone through the same procedures as yourself.

Backups are all running fine.

Did you ever find a resolution?