AGION
asked on
How to remove an offline database
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?
Can seomone help me?
you could just detach it if you're able to access it.
ASKER
I also cannot detach it....
can you drop it?
drop database dbname
drop database dbname
ASKER
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.
Msg 942, Level 14, State 4, Line 1
Database 'Ijsselstein' cannot be opened because it is offline.
you don't need to try to connect to the db...run the statement in the context of the master db.
ASKER
I run it from the master database;
like this:
DROP DATABASE [AA]
like this:
DROP DATABASE [AA]
thats odd...it shouldn't matter that it is offline when you try to drop it.
ASKER
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?
Can I do something through Windows browser?
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....
ASKER
move the db files...where are they exactly located?
run this in a db...will give you an idea as to where the others are.
select * from sys.database_files
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
good...it sounds nasty