How to get Database Backup frequency?

Question

User-2001241905 posted

I'm working on a windows app (C#.NET) that is supposed to fetch some database information, for example: Size of database, Instance name,  & Last Backup date. And I am able to get this information using Microsoft.SqlServer.Management.Smo API. There is one more info that I wish to fetch i.e. the Frequency of Database Backup, whether it is Weekly, Daily, or Monthly. Is there anyway to get this information?

~ Raman

Answer 1

User700362322 posted

May be this could Help You: LINK

you can also refer : how to monito scheduled jobs in SQL server 

and GUI of Schedular

Answer 2

User3866881 posted

ramankashyap

Hello,

Maybe you can make a Windows Service to do backup or fetch info from SQL Server table.

But considering this problem is due to SQL Server info, so I suggest you trying to use SQL Server management Studio's backup things，also you can use the 3-rd party tool：

http://www.sql-server-backup.de/en/

Answer 3

User-2001241905 posted

Hi,

I want to know the backup frequency at runtime using C#.Net.

For example, we can set management plans in sql server to schedule automatic backups. You can find an option to choose the frequency that are Daily, Weekly, or Monthly. I need this frequency information at runtime using C#.Net.

To backup/restore data isn't my requirement.

-Raman

Answer 4

User3866881 posted

I need this frequency information at runtime using C#.Net.

Hello again,

Then you can create a Windows Service to deal with the problem for frequent incidents.

Answer 5

User-2001241905 posted

Hello Decker,

Thanks for your prompt reply. I just need to show the frequency on a screen. Why do I need to create a Windows service?

Answer 6

User-1199946673 posted

I just need to show the frequency on a screen.

You can find this information in the systemtable sysschedules