I have a database created in SQL SERVER 2000 developers edition (with
triggers), and I would like to transfer this database into an MSDE instance
using a Microsoft Data Project on a seperate machine.

I have tried to back up the DB and restore it to the MSDE connected project,
but it did not work.

Is this possible and how?

Thanks

Frank

Yes it's possible as long as you aren't restoring a higher
version to a lower version.
When you say it didn't work - what was the exact error
message? What statements are you using to backup and
restore?

-Sue

On Thu, 15 Jun 2006 07:23:02 -0700, Frank Srebot
<FrankSrebot (AT) discussions (DOT) microsoft.com> wrote:

That may be the case.

The error is as follows:


[Microsoft][ODBC SQL Server Driver][SQL Server]Device activation error.The
Physical filename 'E:\Program Files\Microsoft SQL Server\MSSQL\data\FGS
Tables_Data.MDF' may be incorrect.

[Microsoft][ODBC SQL Server Driver][SQL Server] File 'FGS Tables_Data.MDF'
restored to
'E:\Program Files\Microsoft SQL Server\MSSQL\data\FGS Tables_Data.MDF'. Use
WITH MOVE to identify a valid location for the file.

the same error continues referencing the 'E:\Program Files\Microsoft SQL
Server\MSSQL\data\FGS Tables_Log.LDF' file

Also, it is possible to drop a database from MSDE using Access project?

The version of MSDE is the most current. The sql developers edition has been
updated.

Thanks

Frank


"Sue Hoegemeier" wrote:

The answer is in the error message. You need to use the with
move option to move the data, log files to a valid location
on the new box. You can get information on the logical file
names and physical file locations from the backup using
restore filelistonly. That will give you the information you
need to supply to the with move command.
Restore database and with move are documented in books
online as is restore filelistonly.

-Sue

On Thu, 15 Jun 2006 13:49:03 -0700, Frank Srebot
<FrankSrebot (AT) discussions (DOT) microsoft.com> wrote:

I Will Try That and post my success!

Thank you so much!!

Frank



"Sue Hoegemeier" wrote:

HI

I still have not been successful in restoring. I do not know how to
incorporate the WITH MOVE statement in an Access 2002 project. I looked up
the info in the microsoft website, but they give no specifics on how to use
these statements. Is there any feature which allows you to restore a database
from SQL Server 2000 developer to MSDE. I need reference to an Acess 2002
access data project (.adp) if possible.

Thanks

Frank

"Frank Srebot" wrote: