SQL RESTORE Database

The experience of restoring a backup database.

First, there is a backup of the project file and the corresponding database on hand.

Steps:

1. Find the configuration file in the project file, I found it in the bin directory Config.ini

2. Double-click to open it, there are some information about the database

3. What to change

host=
User=
passwrd=
cur_db=

Host is the computer name; user is the database login username; password is the data login password; cur_db is the database name

You can change these 4 to your own.

4. Then open SQL, log in, select the "Database" folder on the left, right click, see also "original database", select, pop Up "restore Database" interface, "target database" fill in the changed database name (see step 3); then select "Source Device", click "Add" button, and browse, Find your backup file Xxx.bak, click "OK" button

Under normal circumstances, it should be correct, you can view the restored database information on the left; but now this is problematic, the backup database is from SQL2008 R2, and the computer is SQL2008. The following is an error message:

===================================

The media cluster on device ' D:\hssts\last.bak ' is not structurally correct. SQL Server cannot process this media family.
The RESTORE headeronly is terminating abnormally. (. Net SqlClient Data Provider)

------------------------------
For help information, click: Http://go.microsoft.com/fwlink? prodname=microsoft+sql+server&prodver=09.00.3042&evtsrc=mssqlserver&evtid=3241&linkid=20476

------------------------------
Server name: qb-pc\sqlexpress
Error Number: 3241
Severity: 16
Status: 7
Line number: 1

------------------------------

About the difference between SQL 2008 and SQL R2 I'm not sure, let's find out the explanation.

Here is the explanation Baidu found

1. If you are VS2008, then the good fit is SQL 2008 instead of SQL 2008R2
2. If the VS2010 is a good match 2008r2
3.SSRS reproting BUILDER from 2 to 3 this is the thing that lets develop this headache, don't think 2008r2 and 2008 are all compatible, here to tell you, on this issue they are absolutely incompatible
4. Different in SSAS and SSRS on SSAS above understand a lot of hands and feet, specific view of Microsoft website, SSRS provide more icons
5. Both are database software that can be installed independently. R2 has enhanced functionality, such as the addition of PowerPivot for Sharepoint/excel,master Data services, improved reporting Services, and more.
For details, please refer to: http://technet.microsoft.com/zh-cn/library/bb500435.aspx

SQL RESTORE Database