Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the method of restoring a high version of sqlserver database backup to a lower version. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Problem description: high version sql backup restore problem in low version sql (incorrect structure of media family)

Analysis reason: sql version compatibility problem, sql server compatibility level is used for backward compatibility, higher version of sql backup is not compatible in lower version.

Solution:

1, through the manager's script generation wizard, generate scripts for other databases, tables, stored procedures and other objects, and then create these objects under the lower version of sql server.

2. Import the data in the table through dts/ssis.

Here we will introduce the first development method in detail (take other sql2008 databases restored to sql2005 as an example).

1. First, we generate scripts in sql2008 that correspond to other databases.

two。 We click "next" in the generate script interface.

3. Click Advanced in the step of setting scripting options, and set the data type of script to be written and scripting for server development to sql server 2005 and Architecture and data.

4. Next, next, generate our script file.

5. Create another database with the same name in another database in sql server 2005.

6. Open the script and select the corresponding other database.

7. Analyze and execute script queries.

8. Done.

After reading the above, do you have any further understanding of the method of restoring a high-version backup of a sqlserver database to a lower version? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.