?
Solved

syntax question

Posted on 2011-04-29
3
Medium Priority
?
265 Views
Last Modified: 2013-11-05

I installed a NAMED instance as Latin1_General_CP1_CI_AS instead of SQL_Latin1_General_CP1_CI_AS and I am going to attempt to rebuild master.

Hopefully you will not think this question too dumb....  

Will my systax be like this:   (INSTANCENAME=SERVERNAME\INSTANCENAME)
start /wait setup.exe /qb INSTANCENAME=KOCSQLDEV02\AML REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=xxxxxx SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

or this:

OR like this:   (INSTANCENAME=MSSQLSQLERVER\INSTANCENAME)
start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER\AML REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=xxxxxx SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS
??
0
Comment
Question by:itsonlyme4
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
radcaesar earned 2000 total points
ID: 35494140
Yes First one.
0
 

Author Comment

by:itsonlyme4
ID: 35494242
Thanks.   I run this.  it launches the set program then after a few seconds the setup program window disappears.   any idea where I would find a log for this to find out whey it is dying?
0
 

Author Comment

by:itsonlyme4
ID: 35494328
I tried this and it worked:
start /wait setup.exe /qb INSTANCENAME=AML REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=xxxxxx SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

Thanks for your help  : )
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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