Prompt Failed to open the database 'xxDB' in Logs

Publication Date:  2012-07-27 Views:  115 Downloads:  0
Issue Description
Database initialization fails. Check the logs in the C:\HWENGR\logs\logsServer directory and the following message is found:
2008-08-06_10:27:51(DBConnectionManager.getSingleConnection)    finish to getSingleConnection
2008-08-06_10:27:51(CMSSQLConfig.mssqlSetDBOwner)   Begin to set database xxDB's owner to NMSuser
2008-08-06_10:27:51(CMSSQLConfig.mssqlSetDBOwner)   ERROR:Set database xxDB's owner to NMSuser failed
2008-08-06_10:27:51(CMSSQLConfig.mssqlSetDBOwner)   ERROR:java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server] Failed to open the database 'xxDB', because the file cannot be accessed, or the memory or the disk space is insufficient. For details, see the SQL Server error logs.
......


Alarm Information
None.
Handling Process
Step 1     Check the disk space.                               
Step 2    
To delete the database manually, run the following commands:
> isql -Usa -Psa's_password -SDBSVR
1> drop database database_name
2> go
Deleting the xxDB database is considered as an example.
> isql -Usa -Psa's_password -SDBSVR
1> drop database xxDB
2> go
Step 3     Initialize the database again.
Root Cause
Certain database files were deleted or the disk space is insufficient.
Suggestions
 None.

END