x

how can sql server 2000 have mdf file version 611

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.
more ▼

asked Aug 14, 2012 at 02:46 PM in Default

rajeev.awg gravatar image

rajeev.awg
0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.
more ▼

answered Aug 14, 2012 at 02:54 PM

SirSQL gravatar image

SirSQL
4.8k 1 3

Ya I know that. but the system was having sql 2000 how files got version 611.

Going for SQL 2005 & doing all that has lots of problems as First File size is GBs and SP are encrypted, multiple mdfs and schema's keys etc lots of issues.
Aug 14, 2012 at 03:03 PM rajeev.awg
There's no way that could have gotten to 611 off of SQL 2000 that I am aware of (short of it going through a SQL 2005 upgrade)
Aug 14, 2012 at 03:05 PM SirSQL
So I m. But i think sql 2000 can not auto upgraded to sql 2005. And for the sure its not being upgraded.
Aug 14, 2012 at 03:11 PM rajeev.awg

No, there is no automatic upgrade to that version which indicates that you've been given the MDF's from an upgraded version, or that someone attached them to 2005 before giving them to you.

You can see details about the internal database version number at http://technet.microsoft.com/en-us/magazine/2008.08.sqlqa.aspx
Aug 14, 2012 at 03:15 PM SirSQL
Since it isn't possible, something happened. That something is without a doubt that the database was upgraded.
Aug 14, 2012 at 03:19 PM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x473

asked: Aug 14, 2012 at 02:46 PM

Seen: 891 times

Last Updated: Aug 14, 2012 at 03:19 PM