Subscribe to this blog
SQL Server Blog Forum
My name is Muthukkumaran Kaliyamoorthy and I am living in India (Chennai). I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server, and I’m specialized in Administration and Performance tuning.
Archives: March 2012
Find the latest databse backup SQL server
Use the simplest script to find the latest database backup and the location.
SELECT b.server_name ,b.database_name,b.user_name, f.physical_device_name, b.backup_finish_date,b.backup_size /1024/1024 AS size_MB,b.type,b.recovery_model, b.has_bulk_logged_data,b.is_copy_only,f.mirror FROM MSDB.DBO.BACKUPMEDIAFAMILY F JOIN MSDB.DBO.BACKUPSET B ON (f.media_set_id=b.media_set_id) WHERE database_name='test' --AND B.type='L' ORDER BY b.backup_finish_date DESC
You can add more conditions on where clause http://msdn.microsoft.com/en-us/library/ms186299.aspx. Read more
2 comments, 189 reads
Posted in SQL Server Blog Forum on 5 March 2012