Results 1 to 2 of 2

Thread: Daily backup

  1. Nov 10th, 2008, 03:25 AM #1
    cuterita7
    cuterita7 is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2008
    Posts
    21

    Daily backup

    Hi

    I am new to SQL Server 2005 and I want to back up my database on a daily basis.I want that every day at 2:00 pm an automatic backup(a full back up) to be stored in C:\backups

    Any help
    Reply With Quote Reply With Quote
  2. Nov 10th, 2008, 04:43 AM #2
    FunkyDexter
    FunkyDexter is offline
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    7,957

    Re: Daily backup

    It's actually very easy.

    In Management Studio, open the Management branch of the explorer tree.
    Then open the Maintenance Plan Tab.
    Right click and select New Maintenance Plan.
    Give it a name and it'll open up pane where you can drag various tasks on.
    Simply drag a Backup Database Task onto the plan and define it (the setting are pretty self explanatory) and Bob's your relative of choice.
    The best argument against democracy is a five minute conversation with the average voter - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width