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....