Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lost Transaction undo file

Status
Not open for further replies.

qsac

Programmer
Jan 22, 2002
242
US
I have this database that has been sitting around for quite some time.

Some how i lost the undo file, and the database was loaded in Read-Only mode.

Does anyone know of a way i can bring the databse back to 'With Recovery'?

Thanks
Q
 
UNDO file????? That's an Oracle file.

If you are using SQL Server and your database is not fully recovered (in Standby mode, etc) and you do not have any Transaction Logs (these aren't UNDO logs), then just try running this:

RECOVER DATABASE db_name
WITH RECOVERY

-SQLBill

Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top