CODEWITHSUNDEEP
sqlsql-servert-sql
Daniel
Daniel

Reputation: 668

Accidentally dropped SQL Server database connection

I accidentally dropped SQL Server database connection in SQL Server Management Studio. After i dropped the Connection and pushed "OK" the database was put into single user mode and then the database was taken offline and not shown in the object-explorer.

Is there any Point to rettach the database? I dont find any .BAK Datas or the Databasename in the Restore Options.

I tryed already, but get errors

USE master;  
GO  
ALTER DATABASE MyDB SET MULTI_USER
GO

I hope there is something i can do. Thx

EDIT:

enter image description here

Steps i did right Click on the Database -> Task -> Detach , than i was in the following Windows and clicked on "Drop Conections" and clicked "OK" and than she went into single user mode and went offline. But after a refresh i didnt saw her in my object Explorer. I followed this steps:

Getting exclusive access to restore SQL Server databases

so any way to get into single user mode to get her back?

Upvotes: 2

Views: 729

Answers (1)

alexherm
alexherm

Reputation: 1362

See if any *.mdf files exist in file system for the dropped database. If you find, restore.

Upvotes: 1

Related Questions