The directory structure where database previously was NOT
the same directory structure on the server you are trying
to restore database to.
Edit the directory structure on the 'Options' tab to
change the old directory to the new directory where you
want the data & log files to reside (If you are restoring
through E.M. If not, use MOVE option-See B.O.L.).
>--Original Message--
>Hi,
>I am trying to restore a database from a different server
to my server and
>also with a different name.
>But it gives me an error.
>ODBC-SQLState 42000
>Device Activation Error.
>Does anyone know what this is ?
>Any help is appreciated.
>
>.
>
Thank you very much it worked.
But i had to go to the server rather than my own machine.
I guess it was the directory structure.
warm regards,
Ajit.
"James" <anonymous@.discussions.microsoft.com> wrote in message
news:377601c4c10f$23686190$a301280a@.phx.gbl...[vbcol=seagreen]
> The directory structure where database previously was NOT
> the same directory structure on the server you are trying
> to restore database to.
> Edit the directory structure on the 'Options' tab to
> change the old directory to the new directory where you
> want the data & log files to reside (If you are restoring
> through E.M. If not, use MOVE option-See B.O.L.).
>
> to my server and
No comments:
Post a Comment