We moved to MS SQL Server 2005 Final release after using Beta 2 release. I switched the installations. When I tried to restore the database backups, I got following message.System.Data.SqlClient.SqlError: The database was backed up on a server running version 9.00.0852. That version is incompatible with this server, which is running version 9.00.1399. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&LinkId=20476
Kind of absurd. Any ideas how to solve this out
Unable to restore SQL Server 2005 Beta 2 databases in SS 2005 Final
code_monkey
Spaceman_Bob
check http://www.microsoft.com/downloads/results.aspx displaylang=en&freeText=sql+server+2005+ctp+june
Remember, that you have to install the SQL Server tools manualy after main installation finishes to have management studio available.
mark oppenheim
Upgrade is not supported from beta2 directly to RTM.
The best option:
1. Install a June CTP server from http://www.microsoft.com/sql/2005/productinfo/ctp.mspx. The previous (June) CTP is available in the right hand pane.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
2. Attach or restore your beta2 databases to the June CTP server.
3. The databases upgraded to June CTP can now be attached or restored on RTM server.
Brent Newbury