MSDE - Move database from one MSDE instance to another MSDE instance

I'm trying to move a database from one machine with MSDE
installed to another machine with MSDE installed so that I
can use this database on the 2nd machine.
Is there a procedure in MSDE to copy/backup a database and
restore to another machine?
Thanks in advance.You can backup the database, copy the backup file to the
second machine and then restore the database to the second
machine. You can find more information on backup and restore
in books online. You may also want to refer to the
following:
INF: Moving SQL Server 7.0 Databases to a New Server with
BACKUP and RESTORE
http://support.microsoft.com/?id=304692
You can also use sp_detach_db to detach the mdf, ldf files
from the first machine, copy the mdf, ldf files to the
second machine and then attach the database using
sp_attach_db to attach the files on the second machine.
You'd also want to run this on the first machine to reattach
the files after you have copied them to the second machine.
You can find more information on sp_detach_db and
sp_attach_db in books online. You may also want to refer to
the following:
INF: Moving SQL Server Databases to a New Location with
Detach/Attach
http://support.microsoft.com/?id=224071
-Sue
On Fri, 5 Mar 2004 07:17:15 -0800, "Phil"
<anonymous@.discussions.microsoft.com> wrote:

>I'm trying to move a database from one machine with MSDE
>installed to another machine with MSDE installed so that I
>can use this database on the 2nd machine.
>Is there a procedure in MSDE to copy/backup a database and
>restore to another machine?
>Thanks in advance.|||I'm only using MSDE 2000. How do you manage MSDE 2000 and
use the detach/attach procedures?
Thanks.
>--Original Message--
>You can backup the database, copy the backup file to the
>second machine and then restore the database to the second
>machine. You can find more information on backup and
restore
>in books online. You may also want to refer to the
>following:
>INF: Moving SQL Server 7.0 Databases to a New Server with
>BACKUP and RESTORE
>http://support.microsoft.com/?id=304692
>You can also use sp_detach_db to detach the mdf, ldf files
>from the first machine, copy the mdf, ldf files to the
>second machine and then attach the database using
>sp_attach_db to attach the files on the second machine.
>You'd also want to run this on the first machine to
reattach
>the files after you have copied them to the second
machine.
>You can find more information on sp_detach_db and
>sp_attach_db in books online. You may also want to refer
to
>the following:
>INF: Moving SQL Server Databases to a New Location with
>Detach/Attach
>http://support.microsoft.com/?id=224071
>-Sue
>On Fri, 5 Mar 2004 07:17:15 -0800, "Phil"
><anonymous@.discussions.microsoft.com> wrote:
>
I
and
>.
>|||MSDE has the same system stored procedures as SQL Server.
Additionally, osql comes with MSDE. You can use osql to
execute any of the system stored procedures. So you can run
osql and execute the sp_detach_db and sp_attach_db stored
procedures. You can find examples of attaching and restoring
using osql in the following article:
HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by
Using the Osql Utility
http://support.microsoft.com/?id=325003
-Sue
On Fri, 5 Mar 2004 09:33:20 -0800, "Phil"
<anonymous@.discussions.microsoft.com> wrote:
>I'm only using MSDE 2000. How do you manage MSDE 2000 and
>use the detach/attach procedures?
>Thanks.
>restore
>reattach
>machine.
>to
>I
>and|||Thanks for all your help Sue. I should be able to use the
OSQL utility to manage my MSDE databases just fine.
Thanks again.

>--Original Message--
>MSDE has the same system stored procedures as SQL Server.
>Additionally, osql comes with MSDE. You can use osql to
>execute any of the system stored procedures. So you can
run
>osql and execute the sp_detach_db and sp_attach_db stored
>procedures. You can find examples of attaching and
restoring
>using osql in the following article:
>HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000)
by
>Using the Osql Utility
>http://support.microsoft.com/?id=325003
>-Sue
>On Fri, 5 Mar 2004 09:33:20 -0800, "Phil"
><anonymous@.discussions.microsoft.com> wrote:
>
and
second
with
files
refer
MSDE
that
>.
>