cancel
Showing results for 
Search instead for 
Did you mean: 

Database not backed up

Adam_Simmonds
Level 3
Hello
 
I have a job that runs on my servers once a week and takes a backup of all mssql databases that reside on it. Although it now keeps saying \xxx database cannot be accessed. I can open them fine in sql manager, the databases are alive and online, in the same state they have always been in. I used to have it use ms volume shadow copy service to backup the databases while they run online, but i have disabled that just to see if that was the problem and its still happening.
 
Adam
7 REPLIES 7

Ben_L_
Level 6
Employee
Adam,

Can you post the error message you get on these databases?

Adam_Simmonds
Level 3
When the job completes we get an alert saying this:

This backup set may not contain any data.

Backup of "Firethroat"

And then:

The job completed successfully. However, the following conditions were encountered:

1 files were skipped.

 

Job Log says:

 

Backup- FIRETHROAT
Database \CMISL was not found, or could not be accessed.
The item FIRETHROAT\CMISL in use - skipped.

but this was occuring when i had a shadow agent, which was microsoft shadow copy. so that i could backup inuse items


Ben_L_
Level 6
Employee
Adam,

So when you attempt to backup the database with Open File Option (OFO) turned on, the job gets the above error message?  What happens if you backup the database without turning on OFO?

Just a side note, if you are using the SQL agent, you do not need to use the OFO option for SQL or Exchange database backups.  The SQL/Exchange agents can handle open connections without any issues.

Adam_Simmonds
Level 3
I have created a new job now, that just backs up SQL. so its easier to test. I turned OFO off as suggested. i now recive this error
Errors:
Backup- FIRETHROAT
Database \BEDB was not found, or could not be accessed.
Database \CMISD was not found, or could not be accessed.
Database \CMISL was not found, or could not be accessed.
Database \CMISS was not found, or could not be accessed.
Database \CMISU was not found, or could not be accessed.
Database \master was not found, or could not be accessed.
Database \model was not found, or could not be accessed.
Database \msdb was not found, or could not be accessed.
Database \QLFD was not found, or could not be accessed.
Database \QLFL was not found, or could not be accessed.
Database \QLFT was not found, or could not be accessed.
Database \QLX was not found, or could not be accessed.
Database \RMSD was not found, or could not be accessed.
Database \RMSL was not found, or could not be accessed.
Exceptions:
The item FIRETHROAT\BEDB in use - skipped.
The item FIRETHROAT\CMISD in use - skipped.
The item FIRETHROAT\CMISL in use - skipped.
The item FIRETHROAT\CMISS in use - skipped.
The item FIRETHROAT\CMISU in use - skipped.
The item FIRETHROAT\master in use - skipped.
The item FIRETHROAT\model in use - skipped.
The item FIRETHROAT\msdb in use - skipped.
The item FIRETHROAT\QLFD in use - skipped.
The item FIRETHROAT\QLFL in use - skipped.
The item FIRETHROAT\QLFT in use - skipped.
The item FIRETHROAT\QLX in use - skipped.
The item FIRETHROAT\RMSD in use - skipped.
The item FIRETHROAT\RMSL in use - skipped.
 
It passes all database consistency checks on all databases, but then says that it cant access the databases. The backup exec service account can see the sql server and its databases and i have even gave it write access for one database to test it, but it still doesnt work

Ben_L_
Level 6
Employee
Ok looks like we are going to need to do a bit of debugging to find out what is going on.

On the SQL server stop the Backup Exec Remote Agent service from the services panel in Windows

Bring up the properties of the service, in the Start Parameters box type in -debug, click Start then OK. (if you don't click start before closing the window this doesn't work).

Run the test job you created again that does not have OFO turned on.

Once the job is complete run through this utility on BOTH servers.  Use all 1's for the case number and select upload via FTP when completed.

http://support.veritas.com/docs/285911 

Either post the file names or private message them to me when complete.

Adam_Simmonds
Level 3
We dont have the remote agents installed, as the sql and backupexec live on the same server,

Ben_L_
Level 6
Employee
Adam,

Perform the same steps on the Backup Exec server then.