Automating SQL Server installation for standalone/Clustered using powershell

  • ALIF-662928

    SSCertifiable

    Points: 6054

    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.

  • Perry Whittle

    SSC Guru

    Points: 233859

    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" 😉

  • Cody Konior

    SSCarpal Tunnel

    Points: 4827

    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.

  • Perry Whittle

    SSC Guru

    Points: 233859

    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" 😉

  • codykonior

    SSCommitted

    Points: 1591

    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.

  • Perry Whittle

    SSC Guru

    Points: 233859

    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