Technology sharing how to fully back up the SQL Server 2012 database?

Source: Internet
Author: User
Blog has been built for several years, but because I am a layman, so the beginning of the use of the Zblog asp+access database to build, mainly because of technical shortcomings.
But after several years of finishing and writing, found this system more and more cards, consulted a lot of bloggers, and went to Zblog forum many times, found that because of the database cause, Access database can only build some small station, the data volume has reached the obvious pressure, So recently tried to upgrade and convert access to SQL server2012 Microsoft database, after a few days of tossing and consulting some tall man, finally solved the problem, now access more carefree.
My blog: (读后感http://www.simayi.net读书笔记) The theme of the review of the education of the actual site.

So, today I'm going to learn to use SQL Server 2012 to back up the database, after all, books are important things, once lost or backup errors can have serious consequences.

The steps are as follows:

First step: Login to SQL server2012 database management background: ()


The second step: Select your own database and perform backup operations, and I think it should be more secure to back up the data to their hard drive. ()
I'll go! Is that all right? I don't know what's wrong with my backup? If there is a problem with this backup, I hope you correct me!
Important NOTES:
1. I am the selected full backup.
2. And in the options, overwrite the current backup set.
In addition: There is a way to export data directly, so also OK? Does a full backup not have multiple backup sets and media problems? For large databases must be a differential backup, then you need to back up the backup data to a path is more convenient?

Technology sharing how to fully back up the SQL Server 2012 database?

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.