BackUp - Device Activation Error

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.How are you restoring the database? Using Enterprise Manager or using
RESTORE DATABASE command? Can you show us the command?
It could be that the database files were on a drive letter, that aren't
there in the target machine. In that case, you have to use the WITH MOVE
option of the RESTORE command. Also see RESTORE FILELISTONLY command in SQL
Server Books Online. This will show you the path where the RESTORE command
is trying to place the files.
Last but not the least, you posted to too many groups. Posting this to
.server group would have been sufficient.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Ajit" <adeogade@.thedebtmediator.com> wrote in message
news:%23yuuLsQwEHA.1228@.TK2MSFTNGP10.phx.gbl...
> 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.
>
>|||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...
> 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 for your help.
Restore was the option but that too was not working.
I had to change the directory structure on the options tab.
regards,
Ajit.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e$qcz6QwEHA.1192@.tk2msftngp13.phx.gbl...
> How are you restoring the database? Using Enterprise Manager or using
> RESTORE DATABASE command? Can you show us the command?
> It could be that the database files were on a drive letter, that aren't
> there in the target machine. In that case, you have to use the WITH MOVE
> option of the RESTORE command. Also see RESTORE FILELISTONLY command in
SQL
> Server Books Online. This will show you the path where the RESTORE command
> is trying to place the files.
> Last but not the least, you posted to too many groups. Posting this to
> .server group would have been sufficient.
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Ajit" <adeogade@.thedebtmediator.com> wrote in message
> news:%23yuuLsQwEHA.1228@.TK2MSFTNGP10.phx.gbl...
> > 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.
> >
> >
> >
>