Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  could not start db

Author  Topic  mmunir Starting Member 1 Post Posted - 2009-03-25 : 07:35:29 I have installed SQL 2005 in windows server 2003. Actually, i have a database name QAI on this machine. It stopped working as the drive containing this db became full. when i tried to start this db, i got the following error: 'qai' cannot be opened due to inaccessible files or insufficient memory or disk space. My friend told me to detach the databas and then move some datafiles to the new location.when i detach the databse, i got the following error, Error while closing database 'qai'. Check for previous additional errors and retry the operation. However, the databas was disappered. Now after moving files when i agian try to attach, then the following error comes, e:\data\qai_data.mdf is not a primary database file How can i restore my database?