Changes to the SQL Server 2012 restore Options

Source: Internet
Author: User

Starting with the version of SQL Server 2012, the Backup and restore options for the database are changed in the following 2 details.


First, configure the database settings in the server (instance)

SQL Server 2012 has one more item on the Database Settings tab to specify the default location for database backups.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/7C/wKioL1Sbv3CDq2I9AAPIsPcWpjE204.jpg "title=" SQL Server 2012-Database options. png "alt=" wkiol1sbv3cdq2i9aapispcwpje204.jpg "/>



Ii. new "File" tab when restoring database

1. Options for SQL Server R2

SQL Server R2 automatically changes the destination file to the same name as the current database when restoring the database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/57/7F/wKiom1SbvxSTxLUsAAKsEhoN6Ko723.jpg "style=" float: none; "title=" SQL Server R2-General. png "alt=" wkiom1sbvxstxlusaaksehon6ko723.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/7C/wKioL1Sbv8HywNozAAODZQ7iw_c338.jpg "style=" float: none; "title=" SQL Server R2-options. png "alt=" wkiol1sbv8hywnozaaodzq7iw_c338.jpg "/>


2. Options for SQL Server 2012

When you restore a database, SQL Server 2012 does not automatically change the destination file to the same name as the current database. Instead, it provides a comparative list of source files and target control files, allowing users to freely adjust.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/7C/wKioL1Sbv9-Qa0hGAAK6HGwNQhQ974.jpg "style=" float: none; "title=" SQL Server 2012-General. png "alt=" wkiol1sbv9-qa0hgaak6hgwnqhq974.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/7F/wKiom1SbvzLBa033AAJNXNgj-aM940.jpg "style=" float: none; "title=" SQL Server 2012-options. png "alt=" wkiom1sbvzlba033aajnxngj-am940.jpg "/>


When restoring a backup of an old database to a database, if you forget to modify the target file name, an error "Access Denied" will be given because the destination files already exist.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/80/wKiom1Sb2diytwwmAANsyBsPfdI739.jpg "title=" SQL Server 2012-failure.png "alt=" Wkiom1sb2diytwwmaansybspfdi739.jpg "/>


3. Options for SQL Server 2014

When restoring a database, SQL Server 2014 not only provides a control list of source files and target control files for the user to freely adjust, but also automatically changes the target file to the same name as the current database.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/57/7E/wKioL1Sb2t2wekT7AAJpROQiBS8987.jpg "title=" SQL Server 2014-Options. PNG "alt=" wkiol1sb2t2wekt7aajproqibs8987.jpg "/>



This article is from the "We have chased the MSSQL" blog, please be sure to keep this source http://jimshu.blog.51cto.com/3171847/1595961

Changes to the SQL Server 2012 restore Options

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.