Solved

sql server automated install

Posted on 2014-02-25
2
190 Views
Last Modified: 2014-10-03
We have several SQL Server Installations (Both SQL Server 2005 and SQL Server 2008 R2) that I need to recreate for a Disaster Recovery excersize.

Short of performing an install and creating a configuration file, is there a way to generate the configuration file with a utility or any other way?  

IBM has a very cool Utility called db2rspgn (syntax db2rspgn  -d <directory path for response file / instance profiles> ) which goes out and interogates the DB2 LUW installation and creates what they call a response file which can be used to recreate the installation on any Server.

Does anyone know of a similar Microsoft utility for SQL Server?
0
Comment
Question by:itsonlyme4
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
ID: 39887440
There is no utility that I know of and there could only be a partial one created since you would have to know passwords of the Service Accounts.  If you are using the default accounts that get generated for you, then you could do it.  But SQL 2005 does not have these account types, so something would have to be done for that version.

You could create one by using the items in the documentation.

I may just create a script tonight that would gather the items that you need to run an unattended and then you can tweak the output for those items you cannot get.

Back in a while.
0
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
ID: 39896584
For now you should look at this. There are more parameters that could not be derived, but you have the ability to install completely from the commandline without an answer file.

So you can just create your commandline and go from there.

http://msdn.microsoft.com/en-us/library/ms144259.aspx
0

Featured Post

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!

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

751 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