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 thisHave 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
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
>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
>
>.
>|||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...
> 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
> >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
> >
> >
> >.
> >|||...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:
> 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...
>> 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
>> 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
>>
>> .