Solved

sql server automated install

Posted on 2014-02-25
2
174 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
  • 2
2 Comments
 
LVL 24

Expert Comment

by:DBAduck - Ben Miller
Comment Utility
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
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
How to find duplicates in SQL Server 3 20
encyps queries mssql 15 24
t-sql splitting name column 5 22
Sql query for filter 12 18
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…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now