Issues rebuilding system database on SQL Server Express 2005

Tags:
SQL Server 2005
SQL Server database
SQL Server databases
SQL Server Express
SQL Server Express 2005
I am having some trouble rebuilding the system databases on my SQL Server Express 2005 instance.

While I have had a total system failure, the backups have been good.

I have restored the operating system but obviously there are no SQL system databases present (they were open at the time of the backup). So now I need to rebuild them before I restore the backups.

The setup starts OK when I run the recommended rebuild string:

Start /wait setup.exe /qb INSTANCENAME=<InstanceName>
  REINSTALL=SQL_Engine REBUILDDATABASE=1
    SAPWD=<NewStrongPassword>
I get prompted to reinstall, and therefore overwrite the system databases. Then, just before the databases are copied to the DATA directory, I see the following status message:

 Running action to shutdown instance (Run As Normal User)

     RANU instance Shutdown in progress: MSSQL$INSTANCENAME
After 10 seconds I get the following error message:
Microsoft SQL Server 2005 Setup

 

     The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How
     to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

 

     Retry  /  Cancel
I can only “cancel” the process.

Any ideas why am I getting this? Obviously there are no system databases so the SQL Server service will not start (that’s why I’m rebuilding them).

If this is a Microsoft flaw then it's a pretty major one as the only option seems to be the reinstallation of the entire application.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following