locked
How to get Database Backup frequency? RRS feed

  • 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

    Thursday, September 20, 2012 6:56 AM

All replies

  • 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


    Thursday, September 20, 2012 7:41 AM
  • 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/

    Friday, September 21, 2012 9:40 PM
  • 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

    Friday, October 5, 2012 7:13 AM
  • 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.

    Friday, October 5, 2012 7:29 AM
  • 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?

    Friday, October 5, 2012 7:35 AM
  • User-1199946673 posted

    I just need to show the frequency on a screen.

    You can find this information in the systemtable sysschedules

    Friday, October 5, 2012 5:31 PM