cancel
Showing results for 
Search instead for 
Did you mean: 

Database 'master4IDR' cannot be opened

Lamont_Stratus
Level 3
We are getting the following error when doing SQL backup.

An error occurred on a query to database master4IDR.
Database 'master4IDR' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Checking on the sql server, disk space is not an issue. SQL backups was running fine till the last scheduled run. What could be the cause of this one, any areas to check?

TIA
2 REPLIES 2

NoelR
Level 2

We've just started getting this error.  Backups have been running fine and I haven't made any changes to the selections.  I checked the server and there is no database called 'master4IDR' on our SQL server.  Should I just try to exclude this from my backup?

 

RN

NoelR
Level 2

I found this article from 2004 that may have worked for me.

http://www.symantec.com/business/support/index?page=content&id=TECH31107

If the link doesn't work browse to symantec.com/business/support/index?page-content&id=TECH31107

Basically it said to put a blank folder called 'backup' in the folder C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\.

Officially this solution does not apply to the version of BE that I'm running (BE2010 R3 SP1).  However I did create a folder called 'backup' and placed it in C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1 (Windows 2008 R2) which is a 64 bit OS. 

The only folder in that directory was MSSQL.  I put the backup folder there because there was a folder called backup in the MSSQL directory.

The one backup I've run subsequent to that change did not have a problem.