Backup from server 1 and restore to server2.

Hello .
I use sql enterprise manager to do backup for the database from the
server 1. the file is under .dat. can i use this file and restore it to
another database server ( server2)? If it yes, can you show me how to do
it?
can i use sql enterprise manager to retore sql database server 2 with
backup file .dat?.
Thank you very much.Tri
Why do you persist to use EM for this purpose? Is QA not good?
"Tri" <Tri@.discussions.microsoft.com> wrote in message
news:CDC7229D-22E5-4AA3-B43E-B2C8409DF6A1@.microsoft.com...
> Hello .
> I use sql enterprise manager to do backup for the database from the
> server 1. the file is under .dat. can i use this file and restore it
to
> another database server ( server2)? If it yes, can you show me how to do
> it?
> can i use sql enterprise manager to retore sql database server 2 with
> backup file .dat?.
> Thank you very much.|||Hi
Have you checked out
http://support.microsoft.com/defaul...b;en-us;Q314546 and
http://support.microsoft.com/defaul...ben-us%3b224071 ?
John
"Tri" wrote:

> Hello .
> I use sql enterprise manager to do backup for the database from the
> server 1. the file is under .dat. can i use this file and restore it
to
> another database server ( server2)? If it yes, can you show me how to do
> it?
> can i use sql enterprise manager to retore sql database server 2 with
> backup file .dat?.
> Thank you very much.