Home / server / Questions / 33913
Accepted
Chris Thompson
Asked: 2009-07-01 07:42:18 +0800 CST

MSDE database disappeared after receiving a connection error during a query

  • 772

I have a database running on MSDE with the 2GB limit. I noticed that over the last few days I've been hitting the 2GB limit. I opened the enterprise manager to run a SHRINK.

That didn't do anything, so I run a query to delete table rows for data older than Jan 1, 2009.

After I clicked to run the query, I got a connection error message. When I clicked OK and went back to the database list, I saw that it said "suspect" next to the database.

So, I restarted the SQL Server, and now the database is completely gone. The data files are still in the Data folder.

Is it possible to get the database back?

sql-server database

1 Answers

  1. Best Answer

    Have you tried attaching the .mdf file? Use the Management Studio Express or sp_attach_db.

    JR

    Open Enterprise Manager and connect to your SQL server instance. Now right click Databases and find "Attach Database" (I can't remember if it's under a sub menu). Browse to the .mdf file. I would backup the database files first.

    • 4