Skip to content

Automated install and best practices application for Microsoft SQL Server 2016

Notifications You must be signed in to change notification settings

Absoblogginlutely/SQL2016_Scripted_Install

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

24 Commits
 
 
 
 
 
 
 
 

Repository files navigation

SQL2016_Scripted_Install

This is SQL 2016 scripted install process. There is a best practices script which configures SQL Server with best practices.

A few assumptions here:

--You have SQL Media mounted to the D: drive

--The SSMS silent installer doesn't offer any indication of progress, and has worked about 50% of the time in my testing

--Even though SQL Server 2016 does not require .NET 3.5, Database Mail does. I'm currently waiting to hear back to see if this fixed in CU1

--This looks for updates in C:\SQLUpdates, you may wish to update to a different drive (a network share works well)

--This script puts data files on the E: drive--you may need to change for Azure VMs

--You need to edit the DB Mail settings for your SMTP server.

About

Automated install and best practices application for Microsoft SQL Server 2016

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • PowerShell 100.0%