>-----Original Message-----
>Hi,
>
>There are 2 options:-
>
>1. Perform a backup, copy the file to destination server
and Restore the
>database (no downtime)
>2. Detach the database, copy MDF and LDF to destination,
attach the database
>
>I. Backup and Restore
>
>1. Backup the database from OSQL from command prompt.
>
> c:\> OSQL -Usa -Ppassword -Sserver_name (enter)
>
> 1>backup database dbname to disk='c:\backup\dbanme.bak'
with init
> 2>go
>
>THis will backup the database to c:\backup folder
>
>2. COpy the dbanme.bak to destination server
>
>3. Restore the database using (RESTORE Database command)
from OSQL
>
>II. Detach / Attach
>
>1. detach the database from source server
>
> c:\> OSQL -Usa -Ppassword -Sserver_name (enter)
>
> 1>sp_detach_db <dbname>
> 2>go
>
>2. copy the MDF and LDF to destination server
>
>3. Attach the database in source server (Use SP_ATTACH_DB
procedure - refer
>books online)
>
>4.Attach the database in destination server (Use
SP_ATTACH_DB procedure -
>refer books online)
>
>
>--
>Thanks
>Hari
>MCDBA
>"steve" <anonymous@discussions.microsoft.com> wrote in
message
>news:20ce701c459c8$5d4b3e40$a501280a@phx.gbl...
>> I use an application that stores all its information in
an
>> msde database and i would like to replicate the details
in
>> the live system to a backup system. Any idea which
files i
>> need to copy?
>
>
>.