Red Gate forums :: View topic - I can't see implicit transactions
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

I can't see implicit transactions

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
marcorusso



Joined: 19 Mar 2006
Posts: 20

PostPosted: Sun Mar 19, 2006 4:56 pm    Post subject: I can't see implicit transactions Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Sun Mar 26, 2006 8:54 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
marcorusso



Joined: 19 Mar 2006
Posts: 20

PostPosted: Sun Mar 26, 2006 8:58 pm    Post subject: Implicit transactions in master database Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Mon Mar 27, 2006 6:33 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
marcorusso



Joined: 19 Mar 2006
Posts: 20

PostPosted: Mon Mar 27, 2006 10:35 pm    Post subject: Recovery model Reply with quote

Full recovery model, and I'm sure operations were not bulk inserted.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Sat Apr 01, 2006 9:18 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group