Return
-
Title
Can Toad's Log-Reader be used to recover and not to rollback? -
Description
SITUATION:1. - Database "DB_1" crashed on day 21, it no longer exists.2. - There's a back-up from day 17.3. - Created a new database "DB_2" using the back-up from day 17.4. - For days: 18, 19, 20 and 21, there are ONLY TRANSACTION logs.TRYING TO DO:To use the Toad's Log-Reader ( Tools | Administer | Log Reader ), having the "Read Entire Log File" option selected, to get the INSERTs needed to recreate the data that existed "DB_1" into "DB_2". considering:A) This would be opening logs created in "DB_1" while connected to "DB_2".B) The data for days: 18, 19, 20 and 21 is not in "DB_2".When opening a log from day 20, one is able to see some inserts but not others.Can Toad's Log-Reader be used in these situations? Is it OK that not all INSERTs are there? -
Resolution
No, reading tlog backups that were not taken from the database you are connected to, even if that database was restored from the same full backup the tlog are associated with, is not supported.