
UNSOLVED
Redirected Copy SQL Restore Error
I am receiving an error when attempting a Copy restore of a database to a different server other than the server it was originally running on. The two servers are identical (one is in production, the other is test). The partitions are the same, same hardware specs, etc. The database is a 106gb database that was used for reference and was deleted a few weeks ago to free up disc space. Now they would like to have it restored to the test server.
Below if the error I receive:
Recovering files of client 'client1' from server 'servername' to client 'client2'.
[3072] 05/24/07 08:51:16 Recovering database 'databasename' into 'databasename' ...
RESTORE database [databasename] FROM virtual_device='virtual_devicename' WITH move 'logicalfile1' to 'logicalfilelocation1', move 'logicalfile2' to 'logicalfilelocation2'
[3072] 05/24/07 08:51:18 Microsoft SQL Server Provider error:
[3072] 05/24/07 08:51:18 Logical file 'logicalfile1' is not part of database 'databasename'. Use RESTORE FILELISTONLY to list the logical file names..
[3072] 05/24/07 08:51:18 RESTORE DATABASE is terminating abnormally..
[3072] 05/24/07 08:51:18 nsrsqlado.cpp(2525): ExecuteFailed event arrived.
[3072] 05/24/07 08:51:19 Error processing SQL database 'databasename'.
nsrsqlrc: unknown XBSA error 1359 (0x54f)
Restore completion time: Thu May 24 08:51:20 2007
Any ideas?
Below if the error I receive:
Recovering files of client 'client1' from server 'servername' to client 'client2'.
[3072] 05/24/07 08:51:16 Recovering database 'databasename' into 'databasename' ...
RESTORE database [databasename] FROM virtual_device='virtual_devicename' WITH move 'logicalfile1' to 'logicalfilelocation1', move 'logicalfile2' to 'logicalfilelocation2'
[3072] 05/24/07 08:51:18 Microsoft SQL Server Provider error:
[3072] 05/24/07 08:51:18 Logical file 'logicalfile1' is not part of database 'databasename'. Use RESTORE FILELISTONLY to list the logical file names..
[3072] 05/24/07 08:51:18 RESTORE DATABASE is terminating abnormally..
[3072] 05/24/07 08:51:18 nsrsqlado.cpp(2525): ExecuteFailed event arrived.
[3072] 05/24/07 08:51:19 Error processing SQL database 'databasename'.
nsrsqlrc: unknown XBSA error 1359 (0x54f)
Restore completion time: Thu May 24 08:51:20 2007
Any ideas?
Responses (1)
Solutions (0)

ble1
6 Operator
•
14354 Posts
•
56186 Points
247
0
Posted May 24th, 2007 11:00