Incomplete Restore

[OrWolf]

I was restoring a database and SQL server ran out of space, however the restore failed to finish correctly. Now when I attempt to open the server in EM I get an error message: Cannot open user default database. Opening master database instead.

Any ideas?

 

[ccuster]

It sounds like your restore did not finish, due to lack of hard drive space. I would clear up some space and retry the restore. Your default is database is not there therefore MSSQL is going to the master instead.

 

[OrWolf]

I can't try the restore again since SQL thinks the MDF is still in use.

 

[JayKusch]

you have a couple options. use the sp_detachdb to detach the database from sq server then delete the MDF and LDF for that DB. or you can do your restore and option to "over write" the DB with your restore.

of course, as stated by the other posts, you need to alleviate your disc shortage problem.