| Author |
Message |
marcorusso
Joined: 19 Mar 2006
Posts: 20
|
 Posted: Sun Mar 19, 2006 4:56 pm Post subject: I can't see implicit transactions |
 |
|
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 |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
|
| Posted: Sun Mar 26, 2006 8:54 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
marcorusso
Joined: 19 Mar 2006
Posts: 20
|
| Posted: Sun Mar 26, 2006 8:58 pm Post subject: Implicit transactions in master database |
|
|
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 |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
|
| Posted: Mon Mar 27, 2006 6:33 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
marcorusso
Joined: 19 Mar 2006
Posts: 20
|
| Posted: Mon Mar 27, 2006 10:35 pm Post subject: Recovery model |
|
|
| Full recovery model, and I'm sure operations were not bulk inserted. |
|
| Back to top |
|
|
Brian Donahue
Joined: 23 Aug 2004
Posts: 6348
Location: Red Gate Software
|
| Posted: Sat Apr 01, 2006 9:18 pm Post subject: |
|
|
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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
|
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
