Restoring Database to a different database on a different server

Dear All,
we have a database A backup on server Y that we would like
to restore as database B on server X.
Can anyone provide me with some guidence on how to do this
Have a look at HOW TO: Move Databases Between Computers That Are Running SQL
Server
http://support.microsoft.com/default...b;en-us;314546
"Mia" <anonymous@.discussions.microsoft.com> wrote in message
news:2b2a01c509d2$ce2ffa00$a501280a@.phx.gbl...
> Dear All,
> we have a database A backup on server Y that we would like
> to restore as database B on server X.
> Can anyone provide me with some guidence on how to do this
|||Thanks Ana

>--Original Message--
>Have a look at HOW TO: Move Databases Between Computers
That Are Running SQL
>Server
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;314546
>
>"Mia" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:2b2a01c509d2$ce2ffa00$a501280a@.phx.gbl...
like[vbcol=seagreen]
this
>
>.
>
|||Mia
Another option
RESTORE DATABASE MYNAME FROM DISK =
N'\\RemoteServer\backup\MYNAME_other.BAK'
This have to be an identical path on both servers.
"Mia" <anonymous@.discussions.microsoft.com> wrote in message
news:2b4801c509d8$21ba4a90$a501280a@.phx.gbl...[vbcol=seagreen]
> Thanks Ana
>
> That Are Running SQL
> us;314546
> message
> like
> this
|||...or
RESTORE DATABASE NewName FROM DISK ='\\Remoteserver\...\a_backup.bak WITH
MOVE 'logicalfilename_data' TO 'path to database file',
MOVE 'logicalfilename_log' TO 'path to log file'
Regards
Steen
Uri Dimant wrote:[vbcol=seagreen]
> Mia
> Another option
> RESTORE DATABASE MYNAME FROM DISK =
> N'\\RemoteServer\backup\MYNAME_other.BAK'
> This have to be an identical path on both servers.
>
>
> "Mia" <anonymous@.discussions.microsoft.com> wrote in message
> news:2b4801c509d8$21ba4a90$a501280a@.phx.gbl...