Can't Access Database, SQL 6.5

[Andel]

I tried to restore a backup but failed and now my database says (loading) and can't be opened. I can't do restore again because it can't be opened. I tried to change the mode from sysdatabases table to '0' but it doesn't work. My database is grayed. How can I enable or take out this (loading) status, so that I can restore my backup? Please help!!! Thank You.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[cdukes]

I have had this before in SQLServer 7.

The only way I managed to fix it was to issue a DBCC CheckDB on the master database:

DBCC CheckDb ('Master')

Once you have checked the master database, stop the server and restart it. You should find your loading database has gone.

Hope this helps,

Chris Dukes

 

[Andel]

Chris, thank you for responding. I tried what you have suggested but it didn't work. The only way I can't think of now is to drop and re-create the database. But do you have any other idea? Thanks.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com