Replace the system database to solve the problem that the SQLSERVER service cannot be started

Replacing the system database solves the problem that the SQLSERVER service cannot be started. When the SQLSERVER service cannot be started, we tried to replace the four database masters, models, tempdb, and msdb of the system, the Windows Service started up. I encountered this situation twice. At that time, the customer said that the system could not be used. Check the Windows log and see SQLSE.

Replacing the system database solves the problem that the SQLSERVER service cannot be started. When the SQLSERVER service cannot be started, we tried to replace the four database masters, models, tempdb, and msdb of the system, the Windows Service started up. I encountered this situation twice. At that time, the customer said that the system could not be used. Check the Windows log and see SQLSE.

Replace the system database to solve the problem that the SQLSERVER service cannot be started

When the SQL Server service cannot be started, we tried to replace the four database master, model, tempdb, and msdb of the system, and start the Windows service.

I have encountered this situation twice. The website space, at that time, the customer said that the system could not be used. I checked the Windows Log and saw that the SQL Server service could not be started because of XX. I forgot the specific reason.

Then I sent four system databases on my computer to the customer, asking the customer to replace the four original system databases, and the SQLSERVER service started again.

Our system only creates a maintenance plan in SQLSERVER, so even if you replace the system database, it has little impact. Even if the impact is great, at least let SQLSERVER start.

Of course, the database version must be consistent. We use SQLSERVER2005 for the Hong Kong virtual host, which cannot be remotely maintained at the time. If we rely on our mobile phone to instruct the customer to find out the cause step by step, it is very difficult.

In fact, this solution is what the project manager told us: our project manager is very experienced in website space ~