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.
>
>
|||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[vbcol=seagreen]
> 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...
and
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment