Red Gate forums :: View topic - Can't see any transaction after full restore
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

Can't see any transaction after full restore

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
dandrade



Joined: 30 Sep 2007
Posts: 6

PostPosted: Sun Sep 30, 2007 1:55 am    Post subject: Can't see any transaction after full restore Reply with quote

Our network administrator has a scheduled job, is this the cause?

Here is what he runs everyday:

BACKUP LOG my_db WITH TRUNCATE_ONLY; DBCC SHRINKFILE(my_db_log, 2000);
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6646

PostPosted: Tue Oct 16, 2007 12:43 pm    Post subject: Reply with quote

Thanks for posting. I think this is the cause of the problem, yes. If the log had been truncated, then there are no 'active' transactions to analyze. If you find yourself in this situation, including any transaction log backups in the list of backup files that the new project wizard asks for will help. The transactions that have been backed up will appear in the Log Rescue results, provided you have log backups available all the way back to the specified full backup.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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