Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I want to check the 7 Days backup status... Expand / Collapse
Author
Message
Posted Monday, July 28, 2014 4:20 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 2:56 AM
Points: 168, Visits: 538
Hi All,
If I want to check the 7 Days backup status means how can i check?

Regards
Jagadeesh...


Regards
Chowdary...
Post #1596746
Posted Monday, July 28, 2014 9:24 AM This worked for the OP Answer marked as solution


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, November 24, 2014 5:46 AM
Points: 4,025, Visits: 7,172
You can query the BackupSet and BackupMediaFamily tables in the msdb database:
SELECT  
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
bu.database_name,
bu.backup_start_date,
bu.backup_finish_date,
bu.expiration_date,
CASE bu.type
WHEN 'D' THEN 'Full'
WHEN 'L' THEN 'Log'
WHEN 'I' THEN 'Diff'
ELSE bu.type
END AS backup_type,
bu.backup_size,
bm.logical_device_name,
bm.physical_device_name,
bu.name AS backupset_name,
bu.description
FROM msdb.dbo.backupmediafamily AS bm
INNER JOIN msdb.dbo.backupset AS bu ON bm.media_set_id = bu.media_set_id
WHERE (CONVERT(datetime,bu.backup_start_date, 102) >= GETDATE() - 7)
AND bu.type <> 'L'
ORDER BY
bu.database_name,
bu.backup_finish_date



______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1596919
Posted Monday, July 28, 2014 10:28 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 11:52 AM
Points: 362, Visits: 1,086
Thanks MyDoggieJessie, I hope this answered Chowdary's question. I found the information handy.
Post #1596959
Posted Tuesday, July 29, 2014 5:22 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, December 12, 2014 2:56 AM
Points: 168, Visits: 538
Thank you so much dear MyDoggieJessie....

Regards
Chowdary...
Post #1597225
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse