Dump Database

Asked

Viewed 124 times

3

Is there any way of knowing whether or when a DUMP of a database?

sql sql-server dump

  • Maybe it would be interesting to perform constant DB backups

  • But how to see that a backup was performed?

  • It would be interesting to know which bank you use and which access tool.

1 answer

2

Make a SELECT on the table backupset:

SELECT b.database_name AS base,
       CASE b.type
            WHEN 'D' THEN 'Completo'
            WHEN 'L' THEN 'Log'
            WHEN 'I' THEN 'Diferencial'
            ELSE 'Outro'
        END tipo,
        CONVERT(VARCHAR, b.backup_finish_date, 103) + ' ' + CONVERT(VARCHAR, b.backup_finish_date, 108) AS fim
  FROM msdb.dbo.backupset b
 ORDER BY b.database_name, b.backup_finish_date DESC

backupset

Contains a row for each backup set. A backup set contains the backup of a single successful backup operation.

Browser other questions tagged sql sql-server dump

You are not signed in. Login or sign up in order to post.