Solved

How to remove an offline database

Posted on 2008-10-28
13
1,066 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

 

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

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

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

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

737 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