Forum Discussion

Lamont_Stratus's avatar
Lamont_Stratus
Level 3
19 years ago

Database 'master4IDR' cannot be opened

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
10.x and Earlier
Backup and Recovery
Backup Exec

2 Replies

  • NoelR's avatar
    NoelR
    Level 2
    14 years ago

    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's avatar
    NoelR
    Level 2
    14 years ago

    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.