I tried restoring the database one at a time, unchecking the recovery
box when 
Doing the full restore. I checked the enterprise manager and it shows
the database is loading.
I did try to restore some small database on the same machine and was
able to do the full and diff 
Without any problems. There are no other errors in the logs.


-----Original Message-----
From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM] 
Sent: Thursday, November 21, 2002 8:50 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Trouble restoring SQL database


Ken,

The SQL Server will not allow this backup to be
applied to the previous full backup you restored.
In other words, SQL Server is rejecting this
restore attempt.

Did you specify /RECOVERY=NO on the full restore
(if using the command-line interface)?
Or un-check the Recovery checkbox in the GUI on the
full restore if you are doing the restores
manually one at a time?

Take a look at the SQL Server log and the
VDI error log to see if it gives you any
additional information. Also, check the
Microsoft knowledge base for other ideas.

Thanks,

Del

----------------------------------------------------

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

- Never cut what can be untied.
- Commit yourself to constant improvement.
=========================================================

> I am trying to restore a SQL database and am having trouble with the 
> Diff restore. I can restore the full backup but when I try the diff I 
> get an error that says: [Microsoft][ODBC SQL Server Driver][SQL 
> Server]Cannot apply the backup on device 'TDPSQL-00000798-0000' to 
> database 'Core'. [Microsoft][ODBC SQL Server Driver][SQL 
> Server]RESTORE DATABASE is terminating abnormally. Has anyone had this

> problem? Any ideas?