Post reply

How to delete backups after the job rans

  • February 8, 2011 at 10:19 am

    #149884

    Hello,

    I have a maintance plan which I can't modified,get an error message,that needs to be modified from SQL Server Integration tools and I don't see anyware options to delete backs longer than 7 days.

    Can someone tell me where I can find this option.

    Thank you

  • February 8, 2011 at 10:29 am

    #1283852

    have you ssis installed on your system??

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 8, 2011 at 10:31 am

    #1283854

    maintenance clean up task deletes the old backups according to specified time.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 8, 2011 at 10:32 am

    #1283855

    Very interesting solution here (make sure to read all the comments, the best stuff is in there)

    http://sqlblog.com/blogs/andy_leonard/archive/2009/03/11/xp-delete-file.aspx

  • February 8, 2011 at 10:37 am

    #1283861

    Also, make sure you are having the latest service packs installed. Otherwise, you would see some peculiar error messages on your maintenance plans.

    M&M

  • February 8, 2011 at 11:36 am

    #1283921

    I can't specify there where my backups

  • February 8, 2011 at 11:37 am

    #1283925

    Krasavita (2/8/2011)

    I can't specify there where my backups

    What do you mean???

    Yes you can provide a root folder. And then you have a option for recursive delete for all the subfolders.

  • February 8, 2011 at 1:51 pm

    #1284033

    I only see clean up history on server connection

  • February 8, 2011 at 2:40 pm

    #1284074

    You need to verify the version of your client tools, and the version you are running on the server. Both need to be at least 9.00.3054 or greater (SP2 + patch).

    If your client tools are at a lower version than the database server, you are going to have errors when you try to modify your maintenance plans.

    If your server is at RTM - then you have to have Integration Services installed to run maintenance plans. After SP1 - this is no longer required.

    I would recommend that you upgrade to at least SP3. If possible, SP4 would be a better choice.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • February 9, 2011 at 5:57 am

    #1284369

    i think you have not upgraded to SP3 ..

    Do the upgrade and then let us know.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 9, 2011 at 6:45 am

    #1284415

    How can I check what package I have?

    Thank you

  • February 9, 2011 at 6:50 am

    #1284421

    run it in the master database

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 9, 2011 at 7:03 am

    #1284430

    I have sp3

  • February 9, 2011 at 7:06 am

    #1284434

    SQL 2000 or sql 2005?

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 9, 2011 at 8:35 am

    #1284531

    2005

Viewing 15 posts - 1 through 15 (of 19 total)

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