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?