How to Backup data base in every day

  • Hi all,

    i am using sql servwr 2005

    how to backup the database every day 1Am.

    it will take the autamatically i mean job schedue

    please help me

  • polo.csit (10/6/2009)


    Hi all,

    i am using sql servwr 2005

    how to backup the database every day 1Am.

    it will take the autamatically i mean job schedue

    please help me

    In Management Studio, connect to your server, go to management, you will see maintenance plans, right click on maintenance plan wizard, and go through the wizard selecting the database you want to backup and select the time that you want it to happen.

    if this isnt clear enough for you let me know

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • You can also do it without the maintenance plans.

    http://support.microsoft.com/kb/930615

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

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