I can't see implicit transactions

Undo for SQL Server.

Moderator: eddie davis

I can't see implicit transactions

Postby marcorusso » Sun Mar 19, 2006 4:56 pm

I tried LogRescue but I've seen I'm able only to view explicit transactions (those between BEGIN TRAN and COMMIT TRAN) and no implicit transactions.
Is this a limitation of SQL Log Rescue or I'm missing something?
Thank you

Marco
marcorusso
 
Posts: 20
Joined: Sun Mar 19, 2006 4:52 pm

Postby Brian Donahue » Sun Mar 26, 2006 8:54 pm

Hi Marco,

I'm sorry I couldn't get a firm answer about this. Log Rescue will show all transactions, whether they're inside a begin tran/end tran or not. For instance I have use Log Rescue quite a few times on a database where all of the transactions are ad-hoc updates entered manually in Query Analyzer and was still able to generate a script for them in Log Rescue. There must be some other problem.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Implicit transactions in master database

Postby marcorusso » Sun Mar 26, 2006 8:58 pm

I've got a "master" database which has been strangely modified between two days I know. I'm not able to see any transaction for this database. I recovered a full backup on a different database name, but I also tried to do the analysis on the production server installing required stored procedure.
Log Rescue start to analyze the transaction log (progress bar increment until 100%) but there are no transactions showed at the end.
Any idea of something I should check?

Thanks

Marco
marcorusso
 
Posts: 20
Joined: Sun Mar 19, 2006 4:52 pm

Postby Brian Donahue » Mon Mar 27, 2006 6:33 pm

Hi Marco,

What is the recovery model? If the data had been bulk-inserted, you may not see any of this activity in the log.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Recovery model

Postby marcorusso » Mon Mar 27, 2006 10:35 pm

Full recovery model, and I'm sure operations were not bulk inserted.
marcorusso
 
Posts: 20
Joined: Sun Mar 19, 2006 4:52 pm

Postby Brian Donahue » Sat Apr 01, 2006 9:18 pm

Log Rescue is designed to work on 'live' data sources, but you should also be able to restore the database to another server, then give it the full and transaction log backups in the project settings. It will then read the transaction log backups as if they were in the 'live' log.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests