Thursday, March 29, 2012

Error restore backup (sql2000 on w2000 server)

Hi,
I want to restore a backup that we did in another
computer, the name is: CPlus.bak, when I click : Restore...
(I used restore 'from device:').. it issues this
message: "Device activation error. The physical file
name "F:\MSSQL\data\CPlus_Data.MDF" may be
incorrect.File 'CPlus_Data' cannot restored
to 'f:\MSSQL\data\CPlus_Data.MDF'...
...
File 'CPlus_Log' cannot be restored
to 'f:\MSSQL\data\CPlus_Log.LDF'....
give us a light!!!
tia,
AnaHi,
The folder F:\MSSQL\data\?exist, what is BOL.
Thanks,
Ana
>--Original Message--
>Does the new computer have the path F:\MSSQL\data\? If
not
>use "restore...with move" which can be found in BOL.
>>--Original Message--
>>Hi,
>>I want to restore a backup that we did in another
>>computer, the name is: CPlus.bak, when I click :
>Restore...
>>(I used restore 'from device:').. it issues this
>>message: "Device activation error. The physical file
>>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>>incorrect.File 'CPlus_Data' cannot restored
>>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>>....
>>File 'CPlus_Log' cannot be restored
>>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>>give us a light!!!
>>tia,
>>Ana
>>.
>.
>|||BOL = Books On Line . It should be found at Start>Programs>Microsoft SQL
Server>Books Online. Type Restore database into the index to find the syntax
for RESTORE DATABASE
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ana" <anonymous@.discussions.microsoft.com> wrote in message
news:02d801c3b2ab$1753b760$a101280a@.phx.gbl...
Hi,
The folder F:\MSSQL\data\?exist, what is BOL.
Thanks,
Ana
>--Original Message--
>Does the new computer have the path F:\MSSQL\data\? If
not
>use "restore...with move" which can be found in BOL.
>>--Original Message--
>>Hi,
>>I want to restore a backup that we did in another
>>computer, the name is: CPlus.bak, when I click :
>Restore...
>>(I used restore 'from device:').. it issues this
>>message: "Device activation error. The physical file
>>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>>incorrect.File 'CPlus_Data' cannot restored
>>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>>....
>>File 'CPlus_Log' cannot be restored
>>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>>give us a light!!!
>>tia,
>>Ana
>>.
>.
>|||SQL Server Books Online.
>--Original Message--
>Hi,
>The folder F:\MSSQL\data\?exist, what is BOL.
>Thanks,
>Ana
>>--Original Message--
>>Does the new computer have the path F:\MSSQL\data\? If
>not
>>use "restore...with move" which can be found in BOL.
>>--Original Message--
>>Hi,
>>I want to restore a backup that we did in another
>>computer, the name is: CPlus.bak, when I click :
>>Restore...
>>(I used restore 'from device:').. it issues this
>>message: "Device activation error. The physical file
>>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>>incorrect.File 'CPlus_Data' cannot restored
>>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>>....
>>File 'CPlus_Log' cannot be restored
>>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>>give us a light!!!
>>tia,
>>Ana
>>.
>>.
>.
>|||Does the new computer have the path F:\MSSQL\data\? If not
use "restore...with move" which can be found in BOL.
>--Original Message--
>Hi,
>I want to restore a backup that we did in another
>computer, the name is: CPlus.bak, when I click :
Restore...
>(I used restore 'from device:').. it issues this
>message: "Device activation error. The physical file
>name "F:\MSSQL\data\CPlus_Data.MDF" may be
>incorrect.File 'CPlus_Data' cannot restored
>to 'f:\MSSQL\data\CPlus_Data.MDF'...
>....
>File 'CPlus_Log' cannot be restored
>to 'f:\MSSQL\data\CPlus_Log.LDF'....
>give us a light!!!
>tia,
>Ana
>.
>

No comments:

Post a Comment