How SQL Server 2008 automatically backs up the database

Source: Internet
Author: User
Tags microsoft sql server management studio microsoft sql server management studio sql server management sql server management studio

In the SQL Server 2008 database. In order to prevent the loss of data we need to back up the database on time. If you want to back up every day, the manual backup will be very troublesome, automatic backup of the words do not need to be so troublesome, as long as the set up, the database will automatically be in the time period you set up. So how do you set up automatic backups? Here are the explanations for you.

Tools/Materials
    • Computer One

    • You install the SQL Server 2008 database.

Method/Step
  1. 1

    In the PC Start menu, select "SQL Server Management Studio" to double-click. In the interface that appears, click the "Connect" button.

  2. 2

    In the Microsoft SQL Server Management Studio interface that appears, select Maintenance plan under Administration, right-click the maintenance plan, click Maintenance Plan Wizard,

  3. 3

    In the SQL Server Maintenance Plan Wizard interface that appears, click Next

  4. In the interface that appears, write the name and description. Then click on "Change" to set top backup plan

  5. In the job schedule properties interface that appears, change the execution time, that is, how often to back up. This should be a daily backup. The interval is changed to "1" and the execution time is 0:00:00 automatically back up the data at 0 points per day.

  6. Once you've changed it, you can see "executing in 0:00:00 every day." Plans will be used from 2014-5-16 onwards. "Then click on the" Next "button

  7. Select the database file that you want to back up in the Select Maintenance task interface. Then click Next.

  8. In the Select Maintenance task order, you can move the order of the database files that you want to back up. then click "Next"

  9. In the Define backup database complete interface, select the database file from the drop-down menu in the back of the database. Then click on the "OK" button

  10. Select the backup path in the Define backup database complete interface. Then click "Next"

  11. Set the path to the report text file in the Select report options interface. Then click "Next"

  12. In the "Completing the wizard" screen that appears, you will see the details of setting up the backup.

  13. This allows the database to be automatically backed up successfully.

    END
Precautions
    • Be sure to start SQL Server Agent and the database will not be backed up automatically.

How SQL Server 2008 automatically backs up the database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.