Automating SQL Server installation for standalone/Clustered using powershell

  • Hi,

    I would like to get any documentation/ scripts where i can simply run it through a central server with my config file and no need of doing anything on the destination host, Please let me know if anyone uses this in their environment.

    Thanks in advance.

  • sql finebuild will auto install a sql server environment for you, you can find it here[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I wish there was a FineBuild presentation video. Apparently it has been demonstrated at user groups a lot in the past and yet there's nothing recorded and viewable online that I could find.

    My main hesitation with it is that the documentation is so copious, and spread over articles so that it's hard to get a complete picture of what it's doing; some of the wording is vague and it would require lots of time and experimentation to go through the code and work out how to operate it properly and what it's doing underneath the covers.

    Up to now though, most DBAs I know have PowerShell written in combination with modifying the configuration files for a semi-automated install. For example we do things like check cluster size of disks, do the install, set up permissions for Hallengren directories, backup directories, grant volume permissions, work out MAXDOP and max server memory, and enable the common trace flags.

    There's also Orchestrator runbooks to script installation within System Centre Configuration Manager. But for a DBA who has time to become an SCCM expert just so that you can get it to install something? Especially when your infrastructure department is going to lock you out of it afterwards because you're a mere DBA and not quite on their level. It's a bit of a nightmare.

  • the author of finebuild is a member of this forum, you could try contacting him directly

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Brian Davis?

    I swear I tried to contact him 3-6 months ago on twitter or email about it - but I looked and couldn't find any record. I'll try again.

  • His username is edvassie

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 6 posts - 1 through 6 (of 6 total)

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