The replacement system database to solve the SQLSERVER service startup problem

The replacement system database to solve the SQLSERVER service startup problem

When the SQLSERVER service does not start up, we tried four database system master, model, tempdb, MSDB to replace, Windows service started.

I have met two times this situation, the customer can not say with the system, view the Windows log to see SQLSERVER service for XX reasons not starting up, the specific reason to forget

Then I put four database on their computer to customers, allow customers to replace the original four database system, SQLSERVER service and start up

Our system is based on SQLSERVER a maintenance plan, so even replace the system database has little effect, even if the impact is very big, at least make SQLSERVER to start up

Of course, the version of the database should be consistent to the line, we use the SQLSERVER2005, was not remote maintenance, if by mobile phone to guide customers to cause a step by step to find the problem is very difficult


In fact, the solution is to the project manager and we said, we project manager is really experienced.~

Posted by Chris at November 23, 2013 - 7:33 PM