SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 SQL Server 2008 R2 licencing		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ma Baker
Starting Member

South Africa
3 Posts
Posted - 04/26/2012 :  05:35:35  Show Profile  Reply with Quote
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 Posts
Posted - 05/01/2012 :  09:00:57  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000