Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 333 reads

Posted in Adeilson Brito on 14 July 2010