Welcome to EMC Consulting Blogs

Problem

SQL express database after attaching to SQL server management studio 2008, produces SQL Dumper to appear on screen and ends up in a status of Recovering.

Cause

This is because when you attach an mdf file in SQL management studio for a sql express database, it sets the Auto Close property to True by default.

Solution

Change the Auto close property to False, after attaching.