Restore of sql server database is producing error.

Hi,
I had to move a database 'accounting' from one server to another. I had back
ed up the database in the first server and then trying to restore in the sec
ond server. I have quite a few databases in the second server that needs to
be operational. However, wh
en I am trying to restore the 'accounting' database from EM, I am getting th
e following error:
Device activation error. The physical file name 'e:\accounts\Data\accounting
.mdf' may be incorrect. File 'accounting_Data' cannot be retored to 'e:\acco
unts\Data\accounting.mdf'. Use WITH MOVE to identify a valid loction for the
file.
Device activation error. The physical file name 'e:\accounts\Data\accounting
.ldf' may be incorrect. File 'accounting_Data' cannot be retored to 'e:\acco
unts\Data\accounting.ldf'. Use WITH MOVE to identify a valid loction for the
Any help as to how to resolve this problem is highly appreciated in advance.
ThanksHi,
This is because you do not have the directory 'e:\accounts\Data' in the new
server. There are 2 options , either craete the directory in E drive
and do the restore again.
seconds option - If you do not have the Edrive then you have to follow the
below steps:-
1. Using Restore filelistonly command identify the logical file names of the
database backup file
RESTORE FILELISTONLY from disk='c:\backup\dbname.bak'
2. With the output of the above query use RESTORE database
RESTORE DATABASE <newdbname> from disk='c:\backup\dbname.bak'
WITH move 'logical_mdf_filename' to 'new physical name with path',
move 'logical_ldf_filename' to 'new physical log name with
path'
Thanks
Hari
MCDBA
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:31F8EFC7-1D4A-486E-87D4-4695018B224B@.microsoft.com...
> Hi,
> I had to move a database 'accounting' from one server to another. I had
backed up the database in the first server and then trying to restore in the
second server. I have quite a few databases in the second server that needs
to be operational. However, when I am trying to restore the 'accounting'
database from EM, I am getting the following error:
> Device activation error. The physical file name
'e:\accounts\Data\accounting.mdf' may be incorrect. File 'accounting_Data'
cannot be retored to 'e:\accounts\Data\accounting.mdf'. Use WITH MOVE to
identify a valid loction for the file.
> Device activation error. The physical file name
'e:\accounts\Data\accounting.ldf' may be incorrect. File 'accounting_Data'
cannot be retored to 'e:\accounts\Data\accounting.ldf'. Use WITH MOVE to
identify a valid loction for the
> Any help as to how to resolve this problem is highly appreciated in
advance.
> Thanks