SQL SERVER Backwards compatibilty mode

Folks

does SQL Server allow me to run backwards compatible mode? i..e deploy a 2005 db on 2008 installable?

our company does not permit 2005 installs but may consider the 2005 db running on a newer server
rutgermonsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
PadawanDBAConnect With a Mentor Operational DBACommented:
You can do this with the compatibility mode of the database.  When you restore a, for example, 2005 db on a 2008 sql server instance, it will restore with the compatibility mode set to 90.  The compatibility mode is a little funny in it's name vs. functionality.  The compatibility mode mostly relates to the cmd parser portion of the relational engine, maintaining partial compatibility with syntax and feature availability.  It does not give you any protection from deprecated features. It also has no impact on the optimizer, so what was once tuned in 2005 may not be tuned in 2008 - the 2005 optimizer is not the same as the 2008 optimizer (I have been bitten by performance degradation in unexpected ways before).

Edit: Last but not least, this should always be considered a stopgap measure to merely allow you to correct syntax issues so that you can bring the compatibility mode up to the native version for the instance.
0
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
you can restore a 2005 db on 2008 db server,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.