SQL Server Daily Backup: A beginner's problem solving method (i)

Source: Internet
Author: User
Tags mssql

In the new access to the database of daily backup, encountered a number of problems, here to share these solutions to the novice, to minimize the time to see this article, good gossip has ended below to get to the point:

A. There is a problem with the version of the SQL Server database that is installed

I was in the company of the new SQL Server database (still doing development, not pay attention to this aspect so wasted on the download, uninstall, the time of repeated installation) version feel the required functionality is basically satisfied, and therefore reduced the attention of this issue, but found that the installed version is a lite version (management function is very small, SQL Server Agent did not have to think that it is the function of their choice to leak, and then reinstall in the feature selection select the full selection after continuing to install, but after the installation or this appearance, only the attention, then everyone notice, if you download the version behind with the Express Then basically is the lite version, I use SQL Server 2012 Simplified Chinese version, file some big blog garden cannot upload. Remember that if it is a lite version then you have to uninstall reinstall.

Two. Database installation is successful and prompts to disable Agent XP when using maintenance plans

This question is a small problem, there are many blogs or forums have a way to do, here to borrow help me solve the problem of the blog, but also to thank him/her. Paste the code, which runs under the master of the database

sp_configure ' show advanced options ', 1;

GO
RECONFIGURE with OVERRIDE; -Plus with OVERRIDE
GO
sp_configure ' Agent XPs ', 1;
GO
RECONFIGURE with override-Plus with override
GO
sp_configure ' show advanced options ', 1;
GO
RECONFIGURE with OVERRIDE; -Plus with OVERRIDE
GO
sp_configure ' Agent XPs ', 1;
GO
RECONFIGURE with override-Plus with override
GO

Configuration options ' show advanced options ' has changed from 1 to 1. Please run the RECONFIGURE statement to install.
The configuration option ' Agent XPs ' has changed from 0 to 1. Please run the RECONFIGURE statement to install.

This solves the problem. Then, install the Maintenance Plan Wizard.

Three. Define your own backup plan

Tick not show then next (I think too many people like to give you a hint every time you create).

Enter a name for the maintenance plan, and then click "Change ..." to set the time to back up the database, as

After the execution time is set, click "OK", go back to the original window, then click "Next",

In the new window, tick "Back Up Database (full)" and click "Next"

This window is the order in which tasks are executed, because we only set a task, we don't have to do this, just "next"

Select the database we want to back up "test"

It is best to check "create subdirectories for each database" and "Verify backup integrity", expire time and compression, and then click "Next"

This step is mainly how to handle the backup log, we can put in and back up the same directory or use the default directory, if placed in the backup file directory, view will be convenient, click "Next"

You can complete the automatic backup setup by completing the last point.

Finally, our Maintenance Plan Settings window appears, and the backup schedule is not yet executed.

In the Maintenance Plan node under administration and the Jobs node under SQL Server Agent, you can see the backup schedule that we have set up.

You can then run the backup without waiting for the set execution time,

In the maintenance plan, locate the backup plan that we just established, called "Automatic backup Database", right-click on "Execute"

After successful execution, the previously set backup directory D:\Program Files\Microsoft SQL Server\mssql10_50.mssql\mssql\backup See the folder named after the backed up data, and open the folder to see the backup file.

SQL Server Daily Backup: A beginner's problem solving method (i)

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.