Re: not a valid undo file for database
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/05/04
- Next message: Tibor Karaszi: "Re: Calculated field"
- Previous message: Josea Ating: "database recommendations...."
- In reply to: ykchakri: "Re: not a valid undo file for database"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 5 Oct 2004 22:09:36 +0200
The UNDO file is created when you perform RESTORE using the STANDBY option.
This is because SQL Server will actually perform recovery based on the transaction log when you are
using STANDBY, but as you say you want to be able to perform additional restores, SQL Server will
save the recovery work it performs in this undo file so it can undo the recovery work when you do
the next restore.
SQL Server will remember the name of the undo file so it will automatically find it when next
restore is performed. In this case, SQL Server doesn't recognize the undo file as a valid file.
Perhaps someone deleted the file and just created one through notepad, or picked some other UNDO
file and renamed it? Bottom-line is that SLQ Server *need* a valid UNDO file for the next restore.
You can always re-start all restores from the latest database backup.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "ykchakri" <anonymous@discussions.microsoft.com> wrote in message news:2abc01c4ab08$347ecdb0$a501280a@phx.gbl... > Yes, it does. And I've tried renaming this file and then > it gives a different error that the file does not exist. > SO, I'm sure that it is able to access this file, but > something is not right in this file. > > What's the purpose of this file anyway ? > >>-----Original Message----- >>Does the file mentioned in the error message actually > exist? >> >>-- >>Tibor Karaszi, SQL Server MVP >>http://www.karaszi.com/sqlserver/default.asp >>http://www.solidqualitylearning.com/ >> >> >>"ykchakri" <anonymous@discussions.microsoft.com> wrote in > message >>news:21a001c4aa62$329a33a0$a501280a@phx.gbl... >>> Hi, >>> >>> I've restored a database from backup, with STANDBY > option. >>> Now, when I'm trying to apply further Transaction logs > to >>> this database, the restore log command is failing with > an >>> error 'File 'd:\standby.undo' is not a valid undo file > for >>> database 'xyz', database ID 24. >>> >>> Please let me know how to I avoid this error and restore >>> logs to this database. >> >> >>. >>
- Next message: Tibor Karaszi: "Re: Calculated field"
- Previous message: Josea Ating: "database recommendations...."
- In reply to: ykchakri: "Re: not a valid undo file for database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
