Failed Backup 1

[Will192]

I am running Win2000 with SQL2000. My backup has been working fine for a couple of days, until this morning. Here's the error message I got from my nightly backup job:

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 945: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'IEX39' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.

1. I have plenty of backup space - over 1.6 terabytes free on the backup drive
2. No users are logged into the database - test database and server was rebooted after the failed backup
3. I can query the database fine and view a list of tables in Enterprise manager
4. The SQL Server log pretty much says the same thing as the error message, not much help

I tried to create a new maintence job and just backup the problem database. Same error.
I tried to create a new maintence job to optimize the database. Same Error.
I tried to create a new maintence job to reorganize the database. Same Error.

 

[mrdenny]

Check the disk that the database files for the IEX39 database sit on. There may be a drive problem. Can you access the data in Enterprise Manager and Query Analyzer?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[Will192]

Ok, I had to do some research on what other people were doing, but here's the conclusion:

1. Permissions were changed on the drive where the database resides and not rebooted

2. Everyone still had access to the databases on that drive

3. Machine was rebooted a couple days later and when SQL Server was restarted, it was unable to get access to the drive and put the databases into suspect status.

I put the permissions back on the drive and rebooted SQL Server and now everything works fine.

Thanks for any responses to this post.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)