Solved

How to remove an offline database

Posted on 2008-10-28
13
1,065 Views
Last Modified: 2012-05-05
How can I remove an offline database, I cannot bring it online anymore becasue of a failure (set offline failed for Database 'AA'

Can seomone help me?
0
Comment
Question by:AGION
  • 7
  • 6
13 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22823768
you could just detach it if you're able to access it.

0
 

Author Comment

by:AGION
ID: 22824815
I also cannot detach it....
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22824832
can you drop it?

drop database dbname
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:AGION
ID: 22825056
If i Try that using a query if gives me the following message;
 

Msg 942, Level 14, State 4, Line 1
Database 'Ijsselstein' cannot be opened because it is offline.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22825116
you don't need to try to connect to the db...run the statement in the context of the master db.
0
 

Author Comment

by:AGION
ID: 22825147
I run it from the master database;
like this:
DROP DATABASE [AA]
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22825169
thats odd...it shouldn't matter that it is offline when you try to drop it.
0
 

Author Comment

by:AGION
ID: 22825208
I think that there a problem occured when the database was taken down, but no I can't do anything with the DB
Can I do something through Windows browser?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22825243
One thing you could try is to restart sql server and then try it...if it doesn't work then, stop sql server, move the db files, and start it back up....
0
 

Author Comment

by:AGION
ID: 22825261
move the db files...where are they exactly located?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22825293

run this in a db...will give you an idea as to where the others are.

select * from sys.database_files
0
 

Accepted Solution

by:
AGION earned 0 total points
ID: 22849255
It seems to be fixed in SP2 form SQL 2005
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22849261
good...it sounds nasty
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL page split per second is high 19 106
T-SQL to Update Table Dynamically 2 57
SQL 2005 - Memory Table Column Names 11 78
How to import SQL 2000 database to SQL 2014 5 140
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question