Subscribe to this blog
Archives: July 2010
Retrieving last backups of the databases
The script below is a simple and quick way to find out the last backup performed successfully to the databases an SQL server.
select
s.backup_set_id
, s.media_set_id
, s.database_name
, s.server_name
, s.name
, s.recovery_model
, s.backup_start_date
,REVERSE (SUBSTRING (REVERSE (CONVERT… Read more
0 comments, 190 reads
Posted in Adeilson Brito on 14 July 2010