Last post Oct 05, 2012 05:31 PM by hans_v
Sep 20, 2012 06:56 AM|ramankashyap|LINK
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?
Sep 20, 2012 07:41 AM|gnosischief|LINK
May be this could Help You:
you can also refer :
how to monito scheduled jobs in SQL server
GUI of Schedular
Sep 21, 2012 09:40 PM|Decker Dong - MSFT|LINK
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：
Oct 05, 2012 07:13 AM|ramankashyap|LINK
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.
Oct 05, 2012 07:29 AM|Decker Dong - MSFT|LINK
I need this frequency information at runtime using C#.Net.
Then you can create a Windows Service to deal with the problem for frequent incidents.
Oct 05, 2012 07:35 AM|ramankashyap|LINK
Thanks for your prompt reply. I just need to show the frequency on a screen. Why do I need to create a Windows service?
Oct 05, 2012 05:31 PM|hans_v|LINK
I just need to show the frequency on a screen.
You can find this information in the systemtable