moving a db from 2005 to 2000

24 Mar 2006 4:01 PM

Edie Richardson

I have a vendor who uses sql server 2005 but we are currently using 2000 sp4.
He has sent me a mdf, a ldf file and a bak file. I would like to get this
on my ss2k server. What is the best way to do this?

I've tried restoring the bak file but it tells me that there is a
compatibility problem.

I've tried to create a new db, detach and reattach the mdf and ldf file that
the vendor sent and I get the following error:

Error 602: Could not find row in sysindexes for database ID XX, object ID
X, index ID X. Run DBCC Checktable on sysindexes.

Does this mean that I need to run DBCC checktable on sysindexes on the
master db?
I ran this on my ss2k machine. Should the vendor run the dbcc
checktable(sysindexes) on his 2005 machine first and then ship me the mdf and
ldf?

Got to get this somehow, all suggestions are greatly appreciated.

Edie

24 Mar 2006 4:17 PM

Aaron Bertrand [SQL Server MVP]

Could you have the vendor restore the database as a different name on their
2005 server (so as not to disrupt their real copy), change the compatibility
to 80, then back *that* up, and try restoring that on 2000? I haven't tried
that, it's just an outside suggestion.

You could follow the same steps and try it yourself, if you have a 2005
instance available (or could set one up).

Show quote

"Edie Richardson" <EdieRichard***@discussions.microsoft.com> wrote in
message news:E9B97EAB-4F28-4F88-BBAD-D268B4538AE5@microsoft.com...
>I have a vendor who uses sql server 2005 but we are currently using 2000
>sp4.
> He has sent me a mdf, a ldf file and a bak file. I would like to get
> this
> on my ss2k server. What is the best way to do this?
>
> I've tried restoring the bak file but it tells me that there is a
> compatibility problem.
>
> I've tried to create a new db, detach and reattach the mdf and ldf file
> that
> the vendor sent and I get the following error:
>
> Error 602: Could not find row in sysindexes for database ID XX, object ID
> X, index ID X. Run DBCC Checktable on sysindexes.
>
> Does this mean that I need to run DBCC checktable on sysindexes on the
> master db?
> I ran this on my ss2k machine. Should the vendor run the dbcc
> checktable(sysindexes) on his 2005 machine first and then ship me the mdf
> and
> ldf?
>
> Got to get this somehow, all suggestions are greatly appreciated.
>
> Edie

24 Mar 2006 7:12 PM

Tibor Karaszi

You cannot get a 2005 database into 2000 at the binary level (using either restore or attach).
Script and BCP/DTS/BULK INSERT etc is the way to go here. Compatibility level of the database does
not change this.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Edie Richardson" <EdieRichard***@discussions.microsoft.com> wrote in message
news:E9B97EAB-4F28-4F88-BBAD-D268B4538AE5@microsoft.com...
>I have a vendor who uses sql server 2005 but we are currently using 2000 sp4.
> He has sent me a mdf, a ldf file and a bak file. I would like to get this
> on my ss2k server. What is the best way to do this?
>
> I've tried restoring the bak file but it tells me that there is a
> compatibility problem.
>
> I've tried to create a new db, detach and reattach the mdf and ldf file that
> the vendor sent and I get the following error:
>
> Error 602: Could not find row in sysindexes for database ID XX, object ID
> X, index ID X. Run DBCC Checktable on sysindexes.
>
> Does this mean that I need to run DBCC checktable on sysindexes on the
> master db?
> I ran this on my ss2k machine. Should the vendor run the dbcc
> checktable(sysindexes) on his 2005 machine first and then ship me the mdf and
> ldf?
>
> Got to get this somehow, all suggestions are greatly appreciated.
>
> Edie

24 Mar 2006 7:26 PM

Aaron Bertrand [SQL Server MVP]

> Script and BCP/DTS/BULK INSERT etc is the way to go here. Compatibility
> level of the database does not change this.

Ugh, hadn't tried it...