Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

What is the best way to set up a SQL Server deployment that can be easily repeated across multiple virtual servers? Does Microsoft provide something for this, or perhaps Powershell scripts?

share|improve this question

3 Answers 3

up vote 6 down vote accepted

Run the installation of the SQL Server from the command line. The whole thing can be done via a bunch of switches. Save that as a batch file and simply run the batch file.

As for configuring the SQL Server, just write a T/SQL script to handle all the config. Anything you can configure from SSMS you can configure via T/SQL. Just takes a little research.

When I worked for MySpace the SQL Server installation was done this way. Then they would manually configure everything within the SQL Server. This took about 3 hours. I spent a couple of days writing a SQL Script to handle all this, and got it down to about 5 minutes per server.

I used a similar script at another company as well to setup the SQL Servers and it worked really well. It's just a matter how how much you put into the script, and what you have it configure.

If both cases I had it configure the default database locations, database mail, create basic maintenance jobs, set alerts, create SQL Agent operators, etc. The one for MySpace also connected to the central database server and got the most recent copies of the databases and restored them with the correct names.

share|improve this answer
    
This use case microsoft.com/casestudies/… was mentioning also SSB as a tool to aid in the procedures deployment/maintenance across all MySpace server. Of course this is not for deployment of fresh new server installs. –  Remus Rusanu Aug 4 '09 at 7:20
    
They are using SSB for that now? Interesting idea. They were using linked servers when I was there. –  mrdenny Aug 4 '09 at 21:18

You're looking for an unattended install.

share|improve this answer

There is tool called SQL Server FineBuild which also helps with automating deployments

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.