Locally I am running 2008 R2 and on my DBA management server I run 2008 RTM. Today I went to restore a database from my local to my server and received the following awesome error:
The database was backed up on a server running version 10.50.1092. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
My initial thoughts were that (hopefully), it was simply that I was running ‘08 RTM (was only running on RTM to support a small side project that has somewhat died). So I figured it was time to install SP1. Installed and tried again …
The database was backed up on a server running version 10.50.1092. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Awesome.
Granted, it’s the same scenario when going to a newer version with 2005/2008 from a previous version, but from R1 to R2 there is no compatibility (at least of today anyways). This is unfortunate to hear to say the least. It makes me wonder what else will not be supported.
Sometimes I just hate Microsoft. They make some things so easy then go slackjawed with other things. It’s somewhat understandable with as many developers and pieces/parts they have working in SQL, but backups? Disaster recovery should be thier first focus, then feature enhancements and bug fixes.