Restoring SQL2000 bkp file on SQL2005

Is it possible to restore SQL2000 backup to SQL2005? Or I have to restore the DB to SQL2000 and then upgrade it to SQL2005?

Can someone provide me ways to upgrade SQL2000 DB to SQL2005?

Thanks,

Hiten

Simply restore it on the SQL 2k5 server. Backups of 2k are compatible with SQL2k5 (but not vice versa). You have to be aware that the internal (meta) structure of the database is upgraded during the restore process and therefore can′t be backuped and restored on the SQL2k after the upgrade.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Is this possible on SQL 2005 Express too? Or I need to have SQL server 2005 ?|||That also valid for SQL Server 2k5 Express.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

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/defaul...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...
like[vbcol=seagreen]
this[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...[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...

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

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