SQL Server unattended install or configuration response file

  • 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?

  • Don't know of any utility, but I think it would be doable in Powershell - you can get all the SQL config bits using invoke-sqlcmd and all the Windows bits like service accounts from get-wmi.

    There would be some faff to get it into the right format with the values against the parameters, but worth it if you have a lot of servers to rebuild 🙂

  • You can just run the sql server setup wizard ( select all your configuration options ) till the last screen and instead on hitting install, just cancel it.

    But note the location of the config file (.ini file) and change it as per your requirements say yo want to do a silent install ..

    Syntax for the command prompt execution is shown in the link ..

    http://technet.microsoft.com/en-us/library/dd239405(v=sql.100).aspx

    --

    SQLBuddy

  • Check this one as I previously mentioned ..

    http://www.mssqltips.com/sqlservertip/2511/standardize-sql-server-installations-with-configuration-files/

    --

    SQLBuddy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply