#requires -version 2
$erroractionpreference='stop'
cls
$path='D:\BACKUPS'
$sqls="${env:computername}\sql16"
$dbas=-split @'
db1
AdventureWorks2016CTP3
ndoc25
remedy
db2
'@
$diff=@'
select min(differential_base_lsn)lsn
from master.sys.master_files
where database_id=db_id('{0}')
'@
$dbid='select coalesce(db_id(''{0}''),-1)dbid'
$sb=new-object text.stringbuilder
try{
  $smo='Microsoft.SqlServer.Smo'
  [void][reflection.assembly]::loadwithpartialname($smo)
  [void][reflection.assembly]::loadwithpartialname("${smo}Extended")
  $sql=new-object microsoft.sqlserver.management.smo.server $sqls
  $msr=$sql.databases['master']
  $rest=new-object microsoft.sqlserver.management.smo.restore
  $bdev=new-object microsoft.sqlserver.management.smo.backupdeviceitem
  $bdev.devicetype='file'
  $rest.devices.add($bdev)
  $dbas|%{
    if($msr.executewithresults(($dbid -f $_)).tables.dbid -eq -1){
      throw new-object applicationexception "На сервере '$sqls' нет БД '$_'"
    }
#    $fil=join-path $path "$_-$(date -f 'yyyyMMddHHmmss')"
#    $fil=[io.path]::changeextension((join-path $path $_),'bak')
    $fil=join-path $path "$_.bak"
    [void]$sb.appendline("backup database [$_] to"
            ).appendline("disk='$fil'"
            ).append('with noformat,skip,norewind,nounload,checksum,')
    if(test-path $fil){
      $bdev.name=$fil
      $db=$_
      while(1){
        $rest.readbackupheader($sql).rows|?{$_.databasename -eq $db}|
        ?{$_.backuptype -eq 1}|%{
          $ckp=$_.checkpointlsn
          $lsn=$msr.executewithresults($diff -f $db).tables.lsn
          if($lsn -and $lsn -eq $ckp){
            [void]$sb.append('differential,')
            break
          }
        }
      }
      [void]$sb.append('no')
    }
    [void]$sb.appendline('init;').appendline('go')
  }
}catch{[void]$sb.append(($_|out-string|%{"/*$_*/"}))}
write-host $sb.tostring()
#rv * -ea si

#requires -version 2
$erroractionpreference='stop'
cls
$path='D:\BACKUPS'
$sqls="lpc:${env:computername}\sql16"
$dbas=-split @'
AdventureWorks2016CTP3
AdventureWorks2014
StockAnalysis
AdventureWorksDW2014
'@
$diff=@'
select min(differential_base_lsn)lsn
from master.sys.master_files
where database_id=db_id('{0}')
'@
$dbid='select coalesce(db_id(''{0}''),-1)dbid'
$sb=new-object text.stringbuilder
try{
  $smo='Microsoft.SqlServer.Smo'
  [void][reflection.assembly]::loadwithpartialname($smo)
  [void][reflection.assembly]::loadwithpartialname("${smo}Extended")
  $smos=new-object microsoft.sqlserver.management.smo.server $sqls
  $msr=$smos.databases['master']
  $rest=new-object microsoft.sqlserver.management.smo.restore
  $bdev=new-object microsoft.sqlserver.management.smo.backupdeviceitem
  $bdev.devicetype='file'
  $rest.devices.add($bdev)
  $dbas|%{
    if($msr.executewithresults($dbid -f $_).tables[0].rows[0].dbid -eq -1){
      throw new-object applicationexception "На сервере '$sqls' нет БД '$_'"
    }
#    $fil=join-path $path "$_-$(date -f 'yyyyMMddHHmmss')"
#    $fil=[io.path]::changeextension((join-path $path $_),'bak')
    $fil=join-path $path "$_.bak"
    [void]$sb.appendline("backup database [$_] to"
            ).appendline("disk='$fil'"
            ).append('with noformat,skip,norewind,nounload,checksum,')
    if(test-path $fil){
      $bdev.name=$fil
      $db=$_
      foreach($i in 1){
        $rest.readbackupheader($smos).rows|?{$_.databasename -eq $db}|
        ?{$_.backuptype -eq 1}|%{
          $ckp=$_.checkpointlsn
          $lsn=$msr.executewithresults($diff -f $db).tables[0].rows[0].lsn
          if($lsn -and $lsn -eq $ckp){
            [void]$sb.append('differential,')
            break
          }
        }
      }
      [void]$sb.append('no')
    }
    [void]$sb.appendline('init;').appendline('go')
  }
}catch{[void]$sb.append(($_|out-string|%{"/*$_*/"}))}
write-host $sb.tostring()
#rv * -ea si