Chapter 16: SQL server database crashed

TonyS · June 3rd, 2014, 05:25 PM

I had to uninstall SQL Server Express 2012, and then re-install it because I couldn't access it through SQL Server Management Studio.

I then copied the PlanetWrox database from the book code download section into the Site. I was able to open the database with the Management Studio.

I got to the point where I was using the Web Site Administration Tool. I followed the instruction on pages 630 to 631.

I couldn't open the database from within VS by double clicking it; the error message said it couldn't open the Physical file.

So I used Management Studio to try and open it. The database had no information in it and it said "PlanetWrox (Recovery Pending)".

Any idea what might have happened?

Thanks.

Imar · June 4th, 2014, 03:53 AM

This sounds like you may have moved / deleted the underlying database? Or maybe renamed the site's folder or something like that?

Try making a backup of the site including the database files and then delete the database from SQL Server using Management Studio.

Cheers,

Imar

TonyS · June 4th, 2014, 11:09 AM

I didn't move or change anything.

After I rebooted the computer the database came back with all it's data intact including the roles for the users I picked.

It seems that "Visual Studio Express 2012 for Web" is not playing well with the database. It seems to be locking up the database.

Is there a way to get VS to release the database after it is accessed?

Thanks.

Imar · June 4th, 2014, 11:24 AM

Quote:

Is there a way to get VS to release the database after it is accessed?

Yep, you can close the connection to it from the Server or Database Explorer.

Cheers,

Imar