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

backup timings Expand / Collapse
Author
Message
Posted Tuesday, August 21, 2012 1:03 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 21, 2014 2:00 AM
Points: 522, Visits: 2,012
i need to gather info about the backup schedule timings which are scheduled on sunday from the last 3 month s, can any one send the script of hoe to do this
Post #1347594
Posted Tuesday, August 21, 2012 2:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 5,218, Visits: 5,072
The backupset table in MSDB would hold what you want.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1347622
Posted Tuesday, August 21, 2012 5:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:14 AM
Points: 7,197, Visits: 6,341
I'm not quite sure what backup schedule timings means. Are you talking about duration of the backups? Are you talking about how often the backup reoccurs? Are you talking about the time the backups actually start?

Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1347731
Posted Tuesday, August 21, 2012 8:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 11:05 AM
Points: 3, Visits: 166
Try this script, it states the start and end timestamp of each DB backup

USE [msdb]
GO
SELECT rs.[destination_database_name],
rs.[restore_date],
bs.[backup_start_date],
bs.[backup_finish_date],
bs.[database_name] AS [source_database_name],
bmf.[physical_device_name] AS [backup_file_used_for_restore]
FROM [dbo].[restorehistory] rs
JOIN [dbo].[backupset] bs
ON rs.[backup_set_id] = bs.[backup_set_id]
JOIN [dbo].[backupmediafamily] bmf
ON bs.[media_set_id] = bmf.[media_set_id]
ORDER BY rs.[restore_date] DESC
GO

Post #1347843
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse