PCfromDC

Import-Module SQLPS -DisableNameChecking -EA 0
# Get the current date
$date = Get-Date -Format yyyyMMdd
# Set location of backup files
$backupPath = "J:\Backups"
$sqlInstance = $env:COMPUTERNAME
# Grab the Databases
$dbNames = Get-ChildItem "SQLSERVER:\SQL\$sqlInstance\DEFAULT\Databases" | Select Name
# Backup the Databases
foreach ($dbName in $dbNames) {

PCfromDC

Import-Module SQLPS -DisableNameChecking -EA 0

$dbName = "deleteme"
$mdfNewLocation = "G:\Data"
$ldfNewLocation = "H:\Logs"
$sqlSA = "sqlSA"

$domain = $env:USERDOMAIN
$sqlSA = $domain + "\" + $sqlSA
$location = Get-Location

PCfromDC

$destPath = "C:\tempDownloads"
$sp2016preReqPath = Get-Content "$destPath\sp2016preReqPath.txt"
Start-Process "$sp2016preReqPath\PrerequisiteInstaller.exe" -ArgumentList ("/continue /unattended") -Wait

PCfromDC

#Get Backup Path
$bkdir = read-host("Enter Folder Location eg: (C:\temp)") # Get Backup Path!
if ($bkdir.EndsWith("\")){$bkdir = $bkdir.TrimEnd("\")}

# Set Backup Path if you want to hard code your path
#$bkdir = "\\serverName\Shared\Temp" (optional "C:\Temp")

# Verify folder exists
if ((test-path $bkdir) -eq $false ) # Verify folder else create it...
  {

PCfromDC

# set varibles
$sp2016Location = "D:\"  # Change to folder location of SharePoint prerequisiteinstaller.exe file
$destPath = "C:\tempDownloads"
$sp2016preReqPath = Get-Content "$destPath\sp2016preReqPath.txt"

Import-Module Servermanager

#region Create variable paths and copy files
    $sp2016preReqPath = $sp2016preReqPath.TrimEnd('\')
    $sp2016Location = $sp2016Location.TrimEnd('\')

PCfromDC

Import-Module BitsTransfer

$destPath = "C:\tempDownloads" # Change this to desired download destination path
$destPath = $destPath.TrimEnd('\')

#region validate download path
    function validatePath($destFolder){
        ## Check that the path entered is valid
        If (!(Test-Path $destFolder -Verbose)) {
            New-Item -Path $destFolder -ItemType Directory

PCfromDC

#region Create Server 2012R2 Features Array
    function getServer2012R2Features {
        $windows2012R2Features = @(
            "Application-Server",
            "AS-NET-Framework",
            "AS-Web-Support",
            "FileAndStorage-Services",
            "Storage-Services",
            "Web-Server",
            "Web-WebServer",

PCfromDC

$serverName = "SQL03"
$vmName = "3- SQL03"
$vmDest= "G:\VMs\$serverName\"
$isoName = "z_Master-Server2012R2-Standard.vhdx"
$isoPath = "D:\_Images\"
# VM Host Name
$computerName = "Host-HP-01"
# Network 
$switchName = "pcDemo-1"

PCfromDC

$domain = "contoso.local"
$newName ="SQL03"
$OUPath = # to put computer in specific OU
$prefixLength = 24 # PrefixLength of 24 equals a subnet mask of 255.255.255.0

# Update Description
Write-Host -ForegroundColor Green "Updating server description..."
$desc = Get-WmiObject -Class Win32_OperatingSystem
$desc.Description = $newName
$desc.put() 

PCfromDC

# Active Directory Module for PowerShell feature needs to be installed
# spAccounts.csv can be downloaded from: http://1drv.ms/1bHTZC0

Import-Module ActiveDirectory -EA 0

# Create AD Users and Groups

#region Parameters

$file = "C:\DevOps\Microsoft\SQL Server 2014\config\spAccounts.csv"