I have 2 on-premises farms 2013 & 2016. and i want to get all the sharepoint databases names,if they need updates and when they have been backup-ed, now i find this script to get the name and NeedsUpgrade:-
Get-SPDatabase | select Name,NeedsUpgrade
but i am not sure if i can get the last backup date for each database, using the Get-SPDatabase command?
I'm sure there are other, more optimal, solutions but this gets the job done:
$spDbs = Get-SPDatabase
$db = $spDbs[0]
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null
$s = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $db.ServerName
$dbs = $s.Databases
#Retrieves the last backup dates - both for FULL and LOG backups
$outItems = New-Object System.Collections.Generic.List[System.Object]
ForEach($sqlDb in $dbs){
ForEach($spDb in $spDbs){
if($sqlDb.Name -eq $spDb.Name){
$outItems.Add($sqlDb)
}
}
}
$outItems | SELECT Name,LastBackupDate, LastLogBackupDate | Format-Table -autosize
New-Object : Cannot find type [Microsoft.SqlServer.Management.Smo.Server]: make sure the assembly containing this type is loaded.