Posts Tagged ‘Database Backup’

SQL Query To Determine The Last Database Backup Date

This simple script will get list of dates of backups. use msdb SELECT database_creation_date,backup_start_date,backup_finish_date, name, user_name, backup_size FROM backupset WHERE (database_name = N’DataBaseName’) ORDER BY backup_finish_date DESC;

More »