Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
| db:mssql [2021/10/04 15:10] – [MSSQL. SQL administration] admin | db:mssql [2021/11/03 09:53] (current) – admin | ||
|---|---|---|---|
| Line 61: | Line 61: | ||
| <code SQL> | <code SQL> | ||
| -- # Backup Restore/ | -- # Backup Restore/ | ||
| + | |||
| + | -- get backup set | ||
| + | SELECT TOP 100 | ||
| + | name, | ||
| + | type, * | ||
| + | FROM | ||
| + | msdb..backupset | ||
| + | WHERE 1=1 | ||
| + | -- and database_name like ' | ||
| + | ORDER BY | ||
| + | backup_set_id DESC | ||
| -- delete database | -- delete database | ||