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:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 8:50 AM To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] - 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?
