Hello all,

I have a SQL Server 2005 database on my server. I backup the database and copy the file down to my development PC where I am running SQL Server 2008 and I restore the database here. Now when I look at the database properties and compatibility level, it shows as SQL Server 2005 (90), which is what I would expect.

My question is then how come, if the compatibility level is 2005, why can't I backup and then restore from my development PC back to SQL 2005 on the server? And, if I do want to perform this kind of activity, then what do I have to do to be able to do this? Do I need to install SQL 2005 on my development PC also and restore using SSMS 2005?

Also, how does SSMS come into play on this? I prefer to work with SSMS 2008 due to the extra features (such as intellisense) that it offers.

As always, thanks in advance for any advice and pointers.

Bob