Post reply

To stop a backup configured thro'' Entriprise Manager

  • April 13, 2006 at 12:37 am

    #111746

    hi

    can anyone direct how to stop a backup schedule of master db configured in mssqlserver 2000. I have configured this backup schedule using enterprise manager.

    The target location was filled frequently, it eats my hard disk space.

    regards deena

  • April 13, 2006 at 12:19 pm

    #632489

    Hi Deena,

    If you are talking about a backup scheduled using a Maintenance Plan, it is very easy.  Find the Maintenace Plan by opening the Management folder in Enterprise Manager.  Right click on the plan and select "Properties".  You will be able to direct the plan to discard backup files older than x weeks.  Or you could change the location where the files are stored to somewhere with more space available.

     

    Elliott

     

  • April 14, 2006 at 6:40 am

    #632590

    hi Elliott,

    Thanks for ur reply,

    But I have not configured the backup thro' Maintenance Plan,

    For this problem

    I have handled it by searching in Management->SQL Server Agent->Jobs.

    Thanx

    deena

  • April 14, 2006 at 7:14 am

    #632597

    maybe you have the "append to media" selected rather than the "overwrite existing media"?! At any rate, you can still start, stop, edit, delete etc. by rightclicking on the job...







    **ASCII stupid question, get a stupid ANSI !!!**

  • April 14, 2006 at 7:35 am

    #632607

    Exactly

    I have opted "append to media"...

  • April 14, 2006 at 7:49 am

    #632610

    okay - then you just have to change that to "overwrite"...







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 6 posts - 1 through 5 (of 5 total)

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