Friday, August 23, 2013

SQL Server database backup restore on lower version

Using SQL Server 2008 R2 (10.50.1600), which is made a backup file from this server version and you want to restore backup file on my another lower version of server's SQL Server 2008 (10.00.1600). 

is this possible? the answer is NO.

there can be two ways to do that.
1. upgrade the destionation database
2.  "Copy Database" feature

Find by right clicking the source database > "Tasks" > "Copy Database".
You can copy the database to a lower version of SQL Server Instance. this works on from a SQL Server 2008 R2 (SP1) - 10.50.2789.0 to Microsoft SQL Server 2008 (SP2) - 10.0.3798.0

No comments:

Post a Comment