db:mssql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
db:mssql [2021/10/04 14:39] – [MSSQL. SQL administration] admindb:mssql [2021/11/03 09:53] (current) – admin
Line 61: Line 61:
 <code SQL> <code SQL>
 -- # Backup Restore/Mssql -- # Backup Restore/Mssql
 +
 +-- get backup set
 +SELECT TOP 100
 +  name,
 +  type, *
 +FROM
 +  msdb..backupset
 +WHERE 1=1 
 + -- and database_name like '%adm%'
 +ORDER BY
 +backup_set_id DESC
  
 -- delete database -- delete database
Line 199: Line 210:
  
  
-++++ --- SCRIPT - for archive ZIP all files except last one for time|+++++ --- SCRIPT - for archive ZIP all files except last one for sort in time|
 <code BASH> <code BASH>
 Function Zip Function Zip
Line 255: Line 266:
  
 $files = Get-ChildItem $bckpdir\*.* -exclude *.zip | sort -Property CreationTime $files = Get-ChildItem $bckpdir\*.* -exclude *.zip | sort -Property CreationTime
 +
 +if ($files -is [array])
 +{
 $files = $files[0..($files.Count - 2)] $files = $files[0..($files.Count - 2)]
 Zip $files Zip $files
Line 265: Line 279:
    }    }
 } }
 +} 
 +else 
 +{ 
 +   echo  "$(Get-Date -Format o) return is not array - only one file $files" 
 +}
 echo  "$(Get-Date -Format o) === stop" echo  "$(Get-Date -Format o) === stop"
 </code> </code>
  • db/mssql.1633358348.txt.gz
  • Last modified: 2021/10/04 14:39
  • by admin