Say you want to move some hundred SQL databases onto a new SQL server without a lot of boring manual work.
A nice Powershell script is published at Technet:
https://gallery.technet.microsoft.com/scriptcenter/SQL-Server-Auto-Restore-08d8c77f
remember to:
remove the -norecovery switch at the end of the script
import-module SQLPSExample, run the script like this:
.\restoreSQL.ps1 "D:\Backup" "<yourSQLinstance>" "D:\Data" "E:\Logs"I’ve successfully tested this on SQL 2016 and 2017
When swapping out your Sonicwall Gen6 for a newer Gen7 the config needs to be converted,- unless you want to start
Check available optional features: DISM /Online /Get-Capabilities Install an optional feature: DISM /Online /Add-capability /capabilityname:Media.MediaFeaturePack~~~~0.0.1.0
Check AD retention tombstone value: Import-Module ActiveDirectory $ADForestconfigurationNamingContext = (Get-ADRootDSE).configurationNamingContext $DirectoryServicesConfigPartition = Get-ADObject -Identity “CN=Directory Service,CN=Windows NT,CN=Services,$ADForestconfigurationNamingContext” -Partition $ADForestconfigurationNamingContext -Properties *