Problems encountered with SQL Server 2012 database restore

1. In SQL Server2005 and the following version of the database backup to restore, you need to establish a database before the database restore operations, and in SQL Server2005 version of the database restore, do not need to establish a database, you can directly perform database backup operations, Otherwise, a 3154 error is reported when performing a database restore operation.

   END

SQL Server2012 Database restore operation instance

1. 1

   Take the Restore test database as an example.

2. 2

   First start the SQL Server2012 software, expand the left tree, right-click on the "Database" node, pop-up context menu,

3. 3

   Select the "Restore Files and Filegroups (E) ..." feature, pop up the "Restore Files and Filegroups" dialog box, fill in the database name in the "Target database (Q)" column in the restore target, fill in the test, select "Source Device" in the restored source, click the button in the red box on the right,

4. 4

   In the "Specify Backup" dialog box, select the "Add" button, pop up the "Select File" dialog box, select the location of the database backup, select and click Confirm, in the "Specify Backup" dialog box will display the database backup list, select the database backup you want to restore, click OK to start the database recovery,

   At the very beginning, the issue was incompatible with version incompatibility, which was incompatible from a high-version backup to a lower version, so the high-level SQL Server was reinstalled.

   In addition, the process of my backup is to establish a database, then right-click on this database, and then point the backup, so there is always an error, I also file option to change the restore model to full,.mdf and. LDF respectively to the backup file or 3154 error, it is really urgent to die baby, And then according to the above method has succeeded, some of the truth, actually not very understand

Problems encountered with SQL Server 2012 database restore