Shulou(Shulou.com)05/31 Report--

This issue of the content of the editor will bring you about the sql server can not start MSSQL 18052 error: 9003 how to do, the article is rich in content and professional analysis and description for you, after reading this article, I hope you can get something.

Problem: the Syslog file (Control Panel-Administrative tools-Syslog) can find the following two errors: 17052: unable to restore master database. I'm quitting. 18052: error: 9003, severity: 20, status: 1.

Solution 1:

Rename the Microsoft SQL Server/MSSQL/Data directory to the data_bak directory, and then copy the master.mdf,master.ldf,model.mdf,modellog.ldf from other machines and put it anywhere (or directly copy the data directory), not the Microsoft SQL Server/MSSQL/Data directory.

Then open the C:/Program Files/Microsoft SQL Server/80/Tools/Binn folder on the server, find the rebuildm.exe file and run it, reinitialize the master table, select the file, press the next browse, point to the folder that has just been copied from the next computer, click OK to start the reinitialization, and prompt for success (sometimes it may also indicate failure, but it doesn't matter, because it is copied from another computer. Database file link is different), click OK and you can start the SQL service. Sometimes if you can't start, you just need to restart the machine. At this time, just attach the previous database and delete all the doubts that are displayed.

Solution 2:

To reinstall sqlserver, you usually delete it from the control panel, and then delete the installation directory of C:\ Program Files\ sqlserver. If you install it to another disk, delete the x:\ Program Files\ sqlserver folder of the other disk, and then reinstall it.

The above is the editor for you to share the sql server can not start MSSQL 18052 error: 9003 what to do, if there happen to be similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.