Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

sql server automated install

Posted on 2014-02-25
2
Medium Priority
?
195 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 25

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 25

Accepted Solution

by:
DBAduck - Ben Miller earned 2000 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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

660 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