I'm quite new to SQL and no one in my shop knows a lot about it. I've
looked around, tried some stuff, but still am not having any luck.

Here's what is going on. I have a .bak of a database that was made by
SQL 7. We have a new server with Win2k3 SP2, SQL 2000 Enterprise. I
want to take the back-up of the before mentioned database and restore
it in 2000. These are the things I've tried.

A:
1. back-up the db in sql 7
2. create a db in sql 2000
3. restore the backup to the newly created db -- this is where the
restore operation fails, it tells me that "the backup set holds a
backup of a database other than the existing 'new db' database"
4. I'm then supposed to rest the DBO in the new database

B:
1. I've tried using the Copy Database Wizard to copy the db over to
sql 2000 and that failed as well. It was able to migrate the user
names, etc. but not the actual db

What else can I do or how should I proceed? Any information that can
be provided would be greatly appreciated. Thanks in advance for your
help in this matter!

Mike

C:
1. back-up the db in sql 7
2: restore the db in SQL2000

You may need to use the WITH MOVE clause of restore (see BOL for details) if
your disk layout is different between the two servers.
Note that A would work if you use the WITH REPLACE clause (Overwrite
existing database option in EM)

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips


"Mike" <michael.lajoie (AT) gmail (DOT) com> wrote