April 8, 2003 at 10:26 am
Hi,
On ServerA I have a db with a full backup and a second differential. I want to restore both to ServerB but have had no luck. I'm thinking worst case scenario so don't want to 'just do a full backup now and restore to ServerB'.
I have tried running all sorts of variations of the following on ServerB:
RESTORE DATABASE TEST
FROM DISK = 'D:\DUMPS\LIVEDAT.bak'
WITH norecovery,
MOVE 'datafile' TO 'D:\Data\Testdb.mdf',
MOVE 'datafile' TO 'D:\Data\Testdb.ldf',
GO
RESTORE DATABASE TEST
FROM DISK = 'D:\DUMPS\LIVEDAT.bak'
WITH FILE = 2,
MOVE 'datafile' TO 'D:\Data\Testdb.mdf',
MOVE 'datafile' TO 'D:\Data\Testdb.ldf',
RECOVERY
GO
The error message that I receive is:
Cannot apply the backup on device 'D:\Dumps\LIVEDAT.bak' to database 'TEST'.
RESTORE DATABASE is terminating abnormally.
I've also tried in Enterprise Manager and had no joy there. If it makes a difference then ServerA is SQL 7.0 and ServerB is SQL2000.
Any ideas on where I am going wrong.
Many thanks,
April 8, 2003 at 10:45 am
IS the differential backup the one that has erros? or both?. Try running a RESTORE VERIFYONLY on the backups files.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply