如何将SQL Server 2012 sp1 数据库中的数据恢复到低版本数据库中

 

???????????:???????SQL Server 2012 sp1???????,??????,??????????(??SQL Server 2008 R2)??

????????-????????,??????????????

???????,??????????????,??????????????(Database Compatibility Level)????????????????:https://social.technet.microsoft.com/wiki/contents/articles/7009.sql-server-2012-upgrade-and-application-compatibility.aspx

 

SQL Server ? ?	Database Compatibility Level
SQL Server 7	70
SQL Server 2000	80
SQL Server 2005	90
SQL Server 2008	100
SQL Server 2008 R2	105
SQL Server 2012	110

?????,????????????????:https://www.mytechmantra.com/LearnSQLServer/Unable_to_Restore_Database_From_Backup.html

????????:

· ?SQL Server 2012???SQL Server Management Studio

· ?????????,????????,????????“??”

· ??“????”,?????,?????“????”,??????????????????,?????????????SQL Server ???

· ????SQL Server ?????????????,?????

???????????: