Board index MS SQL Server

Drop database marked inaccessable.

Drop database marked inaccessable.

Post by Steve Kalla » Fri, 12 Jan 2001 02:58:57



I have a database which is shown as loading in the Enterprise Mananger
Console Tree.  I aborted a restore yesterday and the database has not yet
recovered.  I wish to delete, recreate, and then restore the database.  How
can I drop the database to begin this process?

Steve Kallal

 
 
 
Top

Drop database marked inaccessable.

Post by Ola Strid » Fri, 12 Jan 2001 03:30:04


Hello, Steve!

You can try to run sp_dbremove in Query Analyzer to drop the database that is
inaccessable.

//Ola Stridh

-----Original Message-----

I have a database which is shown as loading in the Enterprise Mananger
Console Tree.  I aborted a restore yesterday and the database has not yet
recovered.  I wish to delete, recreate, and then restore the database.  How
can I drop the database to begin this process?

Steve Kallal

.


 
 
 
Top

Drop database marked inaccessable.

Post by Steve Kalla » Fri, 12 Jan 2001 03:54:27


I get the following message when running sp_dbremove:

The database 'FIFO' does not exist. Use sp_helpdb to show available
databases.


Hello, Steve!

You can try to run sp_dbremove in Query Analyzer to drop the database that
is
inaccessable.

//Ola Stridh

-----Original Message-----

I have a database which is shown as loading in the Enterprise Mananger
Console Tree.  I aborted a restore yesterday and the database has not yet
recovered.  I wish to delete, recreate, and then restore the database.  How
can I drop the database to begin this process?

Steve Kallal

.

 
 
 
Top

Drop database marked inaccessable.

Post by Ola Strid » Fri, 12 Jan 2001 05:59:19


In Query Analyzer run sp_databases to check if the database FIFO realy exist. You
must run the command sp_dbremove in the master database. Otherwise do a refresh
in Enterprise Manager under databases to see if the status of the database has
changed or does not exist anymore.

//Ola Stridh

-----Original Message-----

I get the following message when running sp_dbremove:

The database 'FIFO' does not exist. Use sp_helpdb to show available
databases.



Hello, Steve!

You can try to run sp_dbremove in Query Analyzer to drop the database that
is
inaccessable.

//Ola Stridh

-----Original Message-----
I have a database which is shown as loading in the Enterprise Mananger
Console Tree.  I aborted a restore yesterday and the database has not yet
recovered.  I wish to delete, recreate, and then restore the database.  How
can I drop the database to begin this process?

Steve Kallal

..

.

 
 
 
Top

1. How to delete inaccessable database?

When I click on one of our databases in SQL 7 Enterprise Manager, the
message "An error occurred while trying to access the database information."
appears.  How do I get rid of the database entry?  If you try and delete it
the error "This database has been marked inaccessable" occurs.

Steve W.

2. Disable Recordset Headings

3. SQL SERVER 6.5 "the database is marked inaccessable and cannot be edited.

4. An Ingres NET question

5. can drop a table marked for replication?

6. email New Data ??

7. Dropping tables marked for replication

8. SQL 2000 setup

9. Can drop a table marked for replication??

10. Value mark in editor drops to debugger on D3/Linus

11. MS-SQL rollback lasts for HOURS, Table inaccessable in meantime

12. Dropping file system files after dropping database devices on SQL 6.5

13. Drop database problem,,, and question on how to mark a database suspect.


All times are UTC
Board index