moving a db from 2005 to 2000

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 an
d
ldf?
Got to get this somehow, all suggestions are greatly appreciated.
EdieCould 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).
"Edie Richardson" <EdieRichardson@.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|||You cannot get a 2005 database into 2000 at the binary level (using either r
estore or attach).
Script and BCP/DTS/BULK INSERT etc is the way to go here. Compatibility leve
l 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/
"Edie Richardson" <EdieRichardson@.discussions.microsoft.com> wrote in messag
e
news:E9B97EAB-4F28-4F88-BBAD-D268B4538AE5@.microsoft.com...
>I have a vendor who uses sql server 2005 but we are currently using 2000 sp
4.
> He has sent me a mdf, a ldf file and a bak file. I would like to get thi
s
> 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 th
at
> 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|||> 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...

Moving a database

I'm very new to SQL Server 2005, so please be kind.

We had a vendor in and they loaded their software and the database
that was created is sitting
on the root (c:) drive. On this server we have another drive where
the database should reside, is
there a way to move this database to the correct drive? Thank you for
any help that you could
provide.

Dave SchaefferDave (dave.schaeffer@.gmail.com) writes:

Quote:

Originally Posted by

I'm very new to SQL Server 2005, so please be kind.
>
We had a vendor in and they loaded their software and the database that
was created is sitting on the root (c:) drive. On this server we have
another drive where the database should reside, is there a way to move
this database to the correct drive? Thank you for any help that you
could provide.

You could try the Copy Database Wizard. Right-click the database in
Object Explorer, and select Tasks and then Copy Database in the
submenu. Select local server for both target and destination. Make
sure you select the attach/detach method (it's selected by default).
At one point you get a database-selection dialog. You can select Move here
instead of copy. Make sure that you have SQL Server Agent.

I will have admit that I give this advice with some hesitation. To wit,
the Copy Database Wizard is very buggy. But attach/detach in the same
server, is so simple so it cannot reasonably not fail. Personally, I
prefer to do this operation with backup/restore, but since you are
very new, you are probably more comfortable with the Wizard for now.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx