Ken W
03-15-2000, 10:10 PM
"Javaid Ahmad" <Javaida@RadixControls.com> wrote:
>
>How can we copy the SQL Server database from one machine to other just by
>coping one or two files(e.g. we copy .mdb file in access database)
>
>Thanks in advance.
>Javaid Ahmad
Alternately, U could backup the source DB in the source machine to backup
device and restore the backup set in the destination machine.
These steps might be involved:
1) Backup the source DB
2) Create the same DB name in the destination machine b4 restoring
3) Use the SQL restore to restore the backup set in the destination
machine.
Enjoy life...
Ken W
>
>How can we copy the SQL Server database from one machine to other just by
>coping one or two files(e.g. we copy .mdb file in access database)
>
>Thanks in advance.
>Javaid Ahmad
Alternately, U could backup the source DB in the source machine to backup
device and restore the backup set in the destination machine.
These steps might be involved:
1) Backup the source DB
2) Create the same DB name in the destination machine b4 restoring
3) Use the SQL restore to restore the backup set in the destination
machine.
Enjoy life...
Ken W