I was having win server 2003 with sql 2000 with all updates. I don't have database backup but I do have mdf ldf files. Now when I re-install win server 2003 & sql 2000 I m not able to attach the db bcoz of error 611 can't be restored in 539. I checked the version of mdf it is 611. So how file on SQL 2000 can have 611 version. If so how can I upgrade sql 2000 with 539 to SQL 2000 with 611.
Another thing is that I do not have option to go for SQL 2005 at all.Please suggest.
asked Aug 14, 2012 at 02:46 PM in Default
I honestly don't see how you can have a SQL 2000 database running at internal version 611 (which is the RTM level for SQL 2005).Either way, unfortunately there is no way that you can attach that database to SQL 2000. At this point your best bet is to install 2005 somewhere and then script out all of the objects, put them in a new database on your 2000 server and then BCP over the data.
answered Aug 14, 2012 at 02:54 PM