cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Agent and Project Server

dvkamm
Level 2
Iam getting the following errors?

So what do I do? The passwords are right I have tested the SA password. The services are running. The SQL DB is availalbe in the selection window? So what is the problem?

************************************

An error occurred on a query to database ProjectServer.
Database 'ProjectServer' cannot be opened because it is offline.
The item myprojectsrver\ProjectServer in use - skipped.

Backup - myprojectsrver An unknown or unexpected database error occurred while attempting a DBCC.
Database 'ProjectServer' cannot be opened because it is offline.

Backup - myprojectsrver
An error occurred on a query to database ProjectServer.
Database 'ProjectServer' cannot be opened because it is offline.
1 REPLY 1

SANDEEP_PILLAY
Level 6
We suggest you to perform the following steps to resolve this issue:
1. Perform a backup with the "Consistency Check before Backup" and "Consistency Check after Backup" options kept to None. These options can be located under the Backup job properties >> SQL option.
2. Verify that the logon account used has administrator rights to the Windows server that the SQL instance is installed on.
3. The consistency check that is run is actually a part of the SQL 2000 program and Backup Exec merely triggers the consistency check. This may also indicate that the database may be in an inconsistent state. Please try running DBCC manually through SQL and check if it reports some error.
- If the DBCC is successful, try running the Backup Job again with SGMON running in the background.

For additional information on SQL Consistency Checker Utility, please refer to the following TechNote:
http://seer.support.veritas.com/docs/242004.htm

We hope this will help.