SQL Server 2005 Backward Compatibility

SQL Server Administration
1

How shold i download SQL Server 2005 Backward Compatibility for SQL 2014

Thanks

2

You can restore a database from two previous versions of SQL Server.

So SQL 2014 can restore a database from SQl2012 or SQL2008 and either SQL2008, or SQL2012, can restore a backup from SQL2005.

Thus you need to install either SQL2008 or SQL2012, restore a backup from SQL2005 (or upgrade the server the database(s) are one) and then backup and repeat again for SQL2014.

1 Like
3

If you meant setting the Compatibility Level then it is not possible to set SQL2005 compatibility level in SQL2014. The same "two previous versions" rule applies

https://msdn.microsoft.com/en-us/library/bb510680.aspx

4

hey Kristen

Thanks for your reply i hope this will help me out .

5

Hey Everyone

Issue resolved

Thanks For your reply.

1 Like