Friday, August 10, 2012

How To check Your Last SQL Database Backup Time

It is good to check when was your last backup happened, I have wrote small query which it pull the information from msdb backupset table, it lists all the database names with last backup date and time. 

It is very easy to track when was your last backup was happened. You can use the following query.

SELECT xx.name AS [Database],
max(backup_finish_date) AS [LastBackupDate]
FROM [master].[dbo].[sysdatabases] xx
LEFT OUTER JOIN [msdb].[dbo].[backupset] xy
ON xy.database_name = xx.name
AND xy.type = 'D'
GROUP BY xx.name
ORDER BY xx.name


Backing Up Your Database. Create a Full Database Backup. Backing Up and Restoring Databases. Have your database ever been backed up. Finding Last Backup Time for All Database. Find out when your SQL Server databases were last backed up. SQL Server database backup restore on lower version. Checking when a database was last backed up. Considerations for Backing Up the master Database. Best Practices for Backing Up Commerce Server. Backup Overview. What is your SQL Server backup strategy. Database.LastLogBackupDate Property. SQL Server 2008 R2. sql server 2012. sql server 2008. sql server 2000. sql server 2005.

0 comments:

Post a Comment