I am getting an error when I start the SQL Server

Asked By 0 points N/A Posted on -
qa-featured

Hi,

Recently there was a power failure, and now I am not able to get my SQL server started.

I am getting the following error.

 

Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

Additional information :

Unable to open the Physical file"c:Program Files Microsoft SQL

ServerMSSQL10_50.SQLEXPRESSMSSQLDATAPRPC61SP2.mdf". Operating system error 2: "2)The system cannot find the file specified.)". (Microsoft SQL Server. Error:5120)

I ran disk scan,  to fix the issue of the file mentioned in the image. But even after that, I cannot start the DB.

John

SHARE
Answered By 0 points N/A #124178

I am getting an error when I start the SQL Server

qa-featured

You can try the regedit option, in the commend prompt to find the file which is missing and put it back in its proper folder.

However, if it does not work, it would be better to use the SQL Configuration Manager.

Since your system could not find a specified file, you can use the Configuration Manager to reconfigure your system and allow the system to recover.

First, add -T3608 as startup parameter.

It will tell the system to start only the master database.

Use the options, Alter Database and Modify File to change the path of the model database.

Then shutdown and restart SQL without -T3608.

About Techyvexpert
Questions
0
Answers
50
Best Answers
10

How do I attach an external SQL Server DB

Previous

How do I scan all the attachments in emails

Next

Related Questions