SQL Error: Restoring backup error, Unable to open physical file

Error:

Msg 5120, Level 16, State 101, Line 1
Unable to open the physical file “C:\Download\TSQL2012.mdf”. Operating system error 2: “2(The system cannot find the file specified.)”.
Msg 5181, Level 16, State 5, Line 1
Could not restart database “TSQL2012”. Reverting to the previous status.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

 

Solution:

Just for database backup and restore testing purposes, I had deleted the master data file (.mdf) of TSQL2012 database then tried to access that database and I have got this error message.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s