Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ma Baker
Starting Member
3 Posts |
 Posted - 2012-04-26 : 05:35:35
|
| 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?Is there another solution to this problem? I cannot afford to buy another SQL Server 2008 R2 licence just for a test-box. |
|
|
chainsaw1997
Starting Member
1 Post |
Posted - 2012-05-01 : 09:00:57
|
| To the best of my knowledge there is no way to restore a backup to a downlevel version of SQL Server. Are you asking if developer is a solution from both a licensing and functionality standpoint? You can indeed restore a production database to a developer edition legally (assuming its being used for development only). Functionally it will work as well. You might want to jump directly to SQL Server 2012 to eliminate similar issues in the future as new releases of SQL Server come out. |
 |
|
|
|
|
|
SQL Server 2008 R2 licencing