Attaching a 2k5 MDF to a 2k Server?

[GrandMauler]

Hi.

I'm attempting to attach an SQL 2k5 mdf and ldf DB (SET TO SQL 2000 COMPATIBILITY) and I keep getting the following message:

"Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes."


I've tried everything I know of with no avail.

The next solution is quite ugly... have all the data in the 2k5 tables exported to the tables in SQL 2000.

Can someone offer me alternative?


Thanks.

 

[ptheriault]

you can not attach or restore a 2005 db to a 2000 server. You would have to use the db copy wizard or DTS to migrate the tables and data.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[GrandMauler]

Somehow, I knew that was going to be the answer... *sigh*

Thanks, Paul.

 

[onpnt]

Is there a reason why you are reverting back to the older version? If you did an upgrade and it was not successful leaving a recovery point on the 2000 version should have part of your planning analysis

_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[GrandMauler]

Is there a reason why you are reverting back to the older version?

The answer to that is simple: Licensing.

We only purchased 2k5 licenses for two servers.

Another license would cost $8k.

 

[onpnt]

I hate it when those little things get in the way ;-)



_{____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood}

 

[GrandMauler]

Yes, I am awaiting the day when MS will not be so "license centric" and just simply be content that their product is being used for the betterment of Mankind.

 

[SQLDenis]

That is not just MS, try using an Oracle license on a multi core hyperthreaded machine

what is it 100% per CPU + 50% per core + 25% per hyperthreading (note: they might have changed it now but this is what it was when multicore/hyperthreading first came out)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions