"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.
>
>
>

"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.
> >
> >
> >
>
>