Restore sql 2000 database .bak file to sql 2005

I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get
is "
Restore failed for Server" - The backup set holds a backup of a
database other than the existing 'db name here ' database.
(Microsoft.SqlServer.Smo)
Pleawse help
Add WITH REPLACE to your RESTORE DATABASE statement if you want to restore
from a backup file of a different database.
Linchi
"CW" <wallacec@.gmail.com> wrote in message
news:1139442397.257269.102990@.g44g2000cwa.googlegr oups.com...
>I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get
> is "
> Restore failed for Server" - The backup set holds a backup of a
> database other than the existing 'db name here ' database.
> (Microsoft.SqlServer.Smo)
> Pleawse help
>
|||RESTORE DATABASE DB_NAME_TO_BE_RESTORED
FROM DISK = 'F:\backupfilename.bak'
WITH MOVE 'Logical_Name_Data' TO 'F:\MSSQL\DATA\Physical_Name_Data.mdf',
MOVE 'Logical_Data_Log' TO 'E:\MSSQL\LOG\Physical_Name_Log.ldf',
STATS = 1, REPLACE
GO
Thanks,
Sree
"Linchi Shea" wrote:

> Add WITH REPLACE to your RESTORE DATABASE statement if you want to restore
> from a backup file of a different database.
> Linchi
> "CW" <wallacec@.gmail.com> wrote in message
> news:1139442397.257269.102990@.g44g2000cwa.googlegr oups.com...
>
>

Restore sql 2000 database .bak file to sql 2005

I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get
is "
Restore failed for Server" - The backup set holds a backup of a
database other than the existing 'db name here ' database.
(Microsoft.SqlServer.Smo)
Pleawse helpAdd WITH REPLACE to your RESTORE DATABASE statement if you want to restore
from a backup file of a different database.
Linchi
"CW" <wallacec@.gmail.com> wrote in message
news:1139442397.257269.102990@.g44g2000cwa.googlegroups.com...
>I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get
> is "
> Restore failed for Server" - The backup set holds a backup of a
> database other than the existing 'db name here ' database.
> (Microsoft.SqlServer.Smo)
> Pleawse help
>|||RESTORE DATABASE DB_NAME_TO_BE_RESTORED
FROM DISK = 'F:\backupfilename.bak'
WITH MOVE 'Logical_Name_Data' TO 'F:\MSSQL\DATA\Physical_Name_Data.mdf',
MOVE 'Logical_Data_Log' TO 'E:\MSSQL\LOG\Physical_Name_Log.ldf',
STATS = 1, REPLACE
GO
Thanks,
Sree
"Linchi Shea" wrote:
> Add WITH REPLACE to your RESTORE DATABASE statement if you want to restore
> from a backup file of a different database.
> Linchi
> "CW" <wallacec@.gmail.com> wrote in message
> news:1139442397.257269.102990@.g44g2000cwa.googlegroups.com...
> >I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get
> > is "
> > Restore failed for Server" - The backup set holds a backup of a
> > database other than the existing 'db name here ' database.
> > (Microsoft.SqlServer.Smo)
> > Pleawse help
> >
>
>sql

Restore sql 2000 database .bak file to sql 2005

I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get
is "
Restore failed for Server" - The backup set holds a backup of a
database other than the existing 'db name here ' database.
(Microsoft.SqlServer.Smo)
Pleawse helpAdd WITH REPLACE to your RESTORE DATABASE statement if you want to restore
from a backup file of a different database.
Linchi
"CW" <wallacec@.gmail.com> wrote in message
news:1139442397.257269.102990@.g44g2000cwa.googlegroups.com...
>I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get
> is "
> Restore failed for Server" - The backup set holds a backup of a
> database other than the existing 'db name here ' database.
> (Microsoft.SqlServer.Smo)
> Pleawse help
>|||RESTORE DATABASE DB_NAME_TO_BE_RESTORED
FROM DISK = 'F:\backupfilename.bak'
WITH MOVE 'Logical_Name_Data' TO 'F:\MSSQL\DATA\Physical_Name_Data.mdf',
MOVE 'Logical_Data_Log' TO 'E:\MSSQL\LOG\Physical_Name_Log.ldf',
STATS = 1, REPLACE
GO
Thanks,
Sree
"Linchi Shea" wrote:

> Add WITH REPLACE to your RESTORE DATABASE statement if you want to restore
> from a backup file of a different database.
> Linchi
> "CW" <wallacec@.gmail.com> wrote in message
> news:1139442397.257269.102990@.g44g2000cwa.googlegroups.com...
>
>