Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Error trying to re-build SQL Server 2008 system databases

Posted on 2009-12-20
8
Medium Priority
?
888 Views
Last Modified: 2012-05-08
I'm issuing the following command at the command prompt:

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=DB\DMO89 /SQLSYSADMINACCOUNTS=BUILTIN\Administrators /SAPWD=[removed] /SQLCOLLATION=Latin1_General_Bin

but i get the error:

Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException

Any ideas why I would be getting this?
0
Comment
Question by:PeterErhard
  • 3
  • 3
7 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 26092689
0
 

Author Comment

by:PeterErhard
ID: 26092699
Thanks angellIII - I read that before posting my questoin, and it doesn't seem to help because it's referring to a brand new install, and not an actual re-build.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 26092718
I feared so...

do you have any service pack/hotfix/ installed?
is the setup the one that is actually installed?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:PeterErhard
ID: 26092747
I have SP1 installed, and using the setup from c:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\release which I presume is current when I upgraded the instance to SP1.

That correct?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 26092766
yes, correct AFAIK.
I fear you need to call MS directly for that, I presume you have support contract for your sql server(s) ?
0
 
LVL 13

Expert Comment

by:St3veMax
ID: 26095262
Can you try running the installer from CD and then re-applying the SP's post RC0 being installed?
0
 

Accepted Solution

by:
PeterErhard earned 0 total points
ID: 26179053
Finished up just doing an un-install, re-install of SQL Server. The fastest way around it, as it was a brand new install in the first place.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question