|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > error while restoring file to a different server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
error while restoring file to a different server
|
|
| eg_madhu@hotmail.com 2002-11-09, 1:23 am |
| Sir,
I have taken backup from a server using a procedure, ie by using 'sp_adddumpdevice' and specified 'disk',filename and location. In order to restore I used one store procedure and specified data base name ( file name+'with replace' +'with move' ). If i trie
d this method to the same server then its okay. But when I used a different server for restore, It shows an error message that ,'No entry found in sysdevices, update it and try again'. Also it is not possible to insert the corresponding information to 'sys
devices' in Master table. How can I solve this problem?
Madhu
******************************
******************************
**********
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
| |
|
| Hi,
What is the version of SQL Server u are working. It seems 6.5. In that case
u need to the database first and then restore.
Regards
Hari.
"Madhu E.G." <eg_madhu@hotmail.com> wrote in message
news:ef1Vew7hCHA.1756@tkmsftngp12...
> Sir,
>
> I have taken backup from a server using a procedure, ie by using
'sp_adddumpdevice' and specified 'disk',filename and location. In order to
restore I used one store procedure and specified data base name ( file
name+'with replace' +'with move' ). If i tried this method to the same
server then its okay. But when I used a different server for restore, It
shows an error message that ,'No entry found in sysdevices, update it and
try again'. Also it is not possible to insert the corresponding information
to 'sysdevices' in Master table. How can I solve this problem?
>
> Madhu
>
> ******************************
******************************
**********
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
| |
| eg_madhu@hotmail.com 2002-11-09, 8:23 am |
| I used the same version for backup and restore.
The backup file I have taken can be restored to the different server through Wizard. But its not possible to done with Storeprocedure. Why?
******************************
******************************
**********
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|
|
|
|
|