Changes to the SQL Server 2012 restore Options

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