Red Gate forums :: View topic - Unavailable data
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

Unavailable data

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



Joined: 08 May 2007
Posts: 2

PostPosted: Tue May 08, 2007 9:55 am    Post subject: Unavailable data Reply with quote

Hi All,

Kindly assist me on sql log rescue. Why im getting unavailable data? Our current setup on our sql server is daily full backup database and transaction log. Now our main goal is to view all transactions, specially on updating and deleting of records on specific date and time and tables. We have just started backing up the transaction log last week april 3, 2007 and the database was last month march 1, 2007. To understand more clearly, I have these backup files.

database: db_20070501.bak, db_20070502.bak,... db_20070508.bak
transaction log: tlog_20070503.trn, tlog_20070504.trn,... tlog_20070508.trn

To test everything, I've been restored the database "db_20070503.bak", and also the transaction logs from tlog_20070503.trn to tlog_20070508.trn. Now, im expecting to view all transactions between this dates 20070503 to 20070508. However, im getting (Unavailable) data on some tables...

1. Why I'm getting unavailable data?
2. What is the best way or procedure to restore the database and viewing all the transactions on especific dates?
3. On the tool wizard "include these backup files", What databases and/or transaction logs should be included to view all transactions?
4. Is this the right tool, to achieve my main goal? Just viewing the transactions on specific date and time and tables? or just wasting my time and money? btw, I've already bought the tool...

Thanks in advance....

Thankfully,
robert1721ph
Back to top
View user's profile Send private message
robert1721ph



Joined: 08 May 2007
Posts: 2

PostPosted: Thu May 10, 2007 7:29 am    Post subject: Reply with quote

Any updates? Is there any tech support or any one could give answer to my concerns??? I have already email them but no one reply to me?

Is this ways of time and money? Is the software have a money back guarantee?
Back to top
View user's profile Send private message
Daniel Handley



Joined: 07 Feb 2005
Posts: 199
Location: Red Gate Software

PostPosted: Wed Oct 24, 2007 10:46 am    Post subject: Reply with quote

Thanks for writing. If the data is unavailabel in the transaction log file, SQL Log Rescue still allows you to use the log backup files in the same way. So if the transactions have been purced from the live log, you can specify the full database backup and an unbroken chain of transaction logs in the backup files window, then SQL Log Rescue will treat the transactions recorded in the log backups as if they were really in the logs.
_________________
Daniel Handley
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
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