Post reply

backup retention information

  • May 13, 2008 at 11:50 am

    #380463

    Please let me know in which table the Backup retention period information is stored in Msdb/Master DB?

    SQL Server 2000 Edition.

    Thanks in advance,

    Manu

  • May 14, 2008 at 8:29 am

    #815249

    As far as I can tell, it is stored in the command column of msdb.dbo.sysjobsteps as an argument passed to master.dbo.xp_sqlmaint. Look for something like:

    -DelBkUps 3DAYS

    I don't see it anywhere else. Have a look at the following tables:

    select * from msdb.dbo.sysjobs

    select * from msdb.dbo.sysjobsteps

  • October 21, 2008 at 12:25 pm

    #887778

    any idea how to check that for sql 2005 ??

    sysjobsteps table has details of an ssis package (which is created for the maint plans). is there a config file for the SSIS package that can be read from TSQL ?

    -------------------------------------------------
    -Amit
    Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply