SQL Server 2008 R2 version differences and backups

[TheJadeDragon]

I run a "non-productive" test server (with SQL Server 2008 vs 10.0.5500), on which I often have to test backups which are backed up on our "production" server (SQL Server 2008 R2 vs 10.50.2500). Of course my backup will not restore because of the version differences.

Can I load a DEVELOPER edition of SQL Server 2008 R2 on my "TEST" server and will this solve the version problems?

Has anyone got a better solution?

I cannot afford to buy another SQL Server 2008 R2 licence just for a test-box.

 

[gmmastros]

The developer version can be used to test your application/database. You cannot use it in a live/production environment.

Sounds like you only want to use it to test, so you should be ok with developer edition. You WILL be able to restore.

If your database is less than 10 gigs, you may also be able to use SQL Express.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom