Post reply

SQL 2000 Back-Up Issues

  • June 3, 2007 at 9:28 am

    #196058

    I am somewhat new to SQL Server 2000.  I recently determined that a database I manage is not being backed-up.  I tested a backup solution that backed-up the database every 1 hour between the hours of 10:00pm and 6:00am and saved the back-ups in a single file.  Once I determined that that solution would work, I created a new backup solution (Using the Maintenance Wizard) that backed-up the database every 12 hours.  That solution works well.  The problem is that I cannot stop the hourly backups and the file is now 20 Gig (the database is only 64k).  Can anyone tell me how to cancel the hourly backups.

     

    Any and all help would be greatly appreciated.   

     

    Mark Clanton

  • June 3, 2007 at 9:53 am

    #710500

    Scheduled Backups become "Jobs"... Find the [Management] folder for the database and expand it... find the [SQL Server Agent] folder under that and expand it... find the [Jobs] folder under that and expand it... find the "offending" job and delete it.  Becareful... no "Undo" here...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 3, 2007 at 10:23 am

    #710502

    Thanks.  I have gone in and deleted the job that I did not want to run.  I will be able to test it tonight.

     

    Thanks for the help.

  • June 8, 2007 at 9:18 pm

    #711824

    Well, everything works great.  Thanks for all of the help.  Great forum.  You will see me again.

     

    Mark

Viewing 4 posts - 1 through 4 (of 4 total)

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