If you need to restore multiple MS SQL DB’s from BAK files, this Community driven Powershell module does the trick (among a whole lot more..)

install in powershell 7.0 with

install-module dbatools

Get help by issuing

get-help *Restore*

and details

get-help Restore-DbaDatabase

Restore your files in specific folder with

restore-dbadatabase -sqlinstance servername -path c:\temp\backup -withreplace

Backup multiple databases

$server = 'servername'
$dblist = 'dbname01','dbname02','dbname03' 
$path = '\\fileshare\Backups\'
Backup-DbaDatabase -SqlInstance $server -Database $dblist -Path $path -Type Full -CopyOnly

Backup all databases

$server = 'servername' 
$path = '\\fileshare\Backups\' 
Backup-DbaDatabase -SqlInstance $server -Path $path -Type Full -CopyOnly

Also after a SQL DB restore it is necessary to re-map SQL user logins.
Windows logins SID is not affected, but a restored SID is not the same as the old. So a T-SQL script like this will resolve nicely

USE DBname

More articles

Optional features

Check available optional features: DISM /Online /Get-Capabilities Install an optional feature: DISM /Online /Add-capability /capabilityname:Media.MediaFeaturePack~~~~

Read More »

AD retention period

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 *

Read More »