restore database

I trying to rrestore a database from BAK file and I get an error microsoft
sql -dmo (odbc sqlstate:4200).
device activation error the physical file *.ldf/*.mdf may be incorrect.
what I am doing wrong.
someone can help me.
Thanks.
Amos
It is probably because you have specified a wrong path to the log file.
I assume you do have enough permissions to the folder.
"amos hchmon" <amoshchmon@.discussions.microsoft.com> wrote in message
news:B2517B74-F209-466D-9124-A49E6CAB6EDA@.microsoft.com...
>I trying to rrestore a database from BAK file and I get an error microsoft
> sql -dmo (odbc sqlstate:4200).
> device activation error the physical file *.ldf/*.mdf may be incorrect.
> what I am doing wrong.
> someone can help me.
> Thanks.
>
|||Is the backup coming from anouher server ?
Try out "restore headeronly" on the .BAK-File and check the results.
Then use the "MOVE" - option on restore to put the data- and log- files
to valid places - as Uri said,
the pahtes must be existing before restore.
|||Uri thnks you for your help.
but I do not understand what I need to do according to your advice.
because the path create automaticly
in the "option" tab when I select device in the "general" tab.
c:\program files\microsoft sql server\mssql\data\anyfile.bak
"Uri Dimant" wrote:

> Amos
> It is probably because you have specified a wrong path to the log file.
> I assume you do have enough permissions to the folder.
>
>
> "amos hchmon" <amoshchmon@.discussions.microsoft.com> wrote in message
> news:B2517B74-F209-466D-9124-A49E6CAB6EDA@.microsoft.com...
>
>
|||Hi Amos,
I see - you are using Enterprise Manager (EM).
So you probably selected "from device" on the restore menu and
navigated to the .BAK file.
EM then reads the information in the header of the .BAK file and wants
to put the files in the same
place where they existed when the DB was being backed up.
You will need to go to "options" and click *into* the lines specifying
the files to restore ("move to physical file")
You can *change* this information.
Change them according to your system (e.g. c:\programs\... or
d:\programs or whatsoever).
|||Hi mattp,
I am a asp.net developer and I get a bak file to restore in my server in the
localhost for test.
I am don't have a DBA manager but I get with the file a text file that
explain what to do I doing step by step by the page and I get this error.
I don't thinks that I need to change the place of the files (ldf,mdf).
because in the default the wizard place them in C:\Program Files\Microsoft
SQL Server\MSSQL\Data when I select the bak file in the general tab,and in
the guide page write the same place.
maybe you want that I place the files in the other place.
"mattp" wrote:

> Hi Amos,
> I see - you are using Enterprise Manager (EM).
> So you probably selected "from device" on the restore menu and
> navigated to the .BAK file.
> EM then reads the information in the header of the .BAK file and wants
> to put the files in the same
> place where they existed when the DB was being backed up.
> You will need to go to "options" and click *into* the lines specifying
> the files to restore ("move to physical file")
> You can *change* this information.
> Change them according to your system (e.g. c:\programs\... or
> d:\programs or whatsoever).
>
|||Do these files already exist there ?
--> then also "checkmark" the option "restore over existing database".
Is there enough space on the drive ?