I am getting an error when I start the SQL Server

Asked By John1qaz 0 points N/A Posted on - 09/15/2011

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

• Status: Open
• Question Views: 930
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Techyvexpert 0 points N/A #124178

I am getting an error when I start the SQL Server

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

• Vote Up 0 Vote Down

• Posted on - 10/04/2011
• Question Category: MS SQL Server