Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bals
Starting Member
4 Posts |
 Posted - 2011-03-04 : 10:25:07
|
| Hi,I have many backup frequency scheduled as Jobs or External CommVault in my server environment. I just want to know if there is a way to identify the backup frequency if it's daily, weekly and monthly scheduled backup. Backup may be either scheduled from Jobs or External CommVault.(So I cannot go with Jobs tables alone)Query needs fetch details from backup History tables. Any comments/suggestion is highly appriciated.Thanks,Bala |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-03-04 : 11:36:35
|
| I'm not sure what you are asking so if I'm way off base, just ignore this.The SQL jobs that are invoked will have a schedule that you can see. Right-click the SQL job, select Properties are you'll find the Schedules option.I don't know how you are invoking the External CommVault but it must have a means of automatically launching on a regular basis.OR, you could look at the backup files themselves to see the timestamp and extrapolate the frequency from there.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
bals
Starting Member
4 Posts |
Posted - 2011-03-04 : 12:28:00
|
| Thanks for the response Bustaz. I have many database and servers to check the backup frequncy,so its time consuming to open each Jobs and check the schdule or open the backup file. CommVault is a third party application which take the backup of SQL server database.so there s no jobs assosiated with SQL server for that.All I had is the backup history table , which have the details successful backup taken.I need to query msdb.dbo.backupset and msdb.dbo.backupmediafamily to get the history , by then to get the frequency schduled based on that history result |
|
|
|
|
|
|
Backup frequency from backup history