Index was outside the bounds of the array

[AlexG]

Hi,
using latest version of your product.
I want to find delete query in log files.

DB is 50GB , log created every 15 min size (400 KB - 300 MB)
full backup done to Tivoli, log backup done to disk, all log files 2 days
older then full backup deleted from disk

stared new project waited till all files examined , got message no Full backup , then application start to analyze log files ,after 5 minutes got message "Index was outside the bounds of the array"

my questions
1. does application needs acess to full backup file ?
2. is it possible to simply read data from from single log file?
3. cause of error above ?

Thanks
AlexG

[AlexG]

Found work around ,but still have few questions

1. deleted backup history older then 7 days

started project -> point on db -> wait till all log files checked-> remove all -> add only log files from my location

here come tricky part
test 1
total number of log files added = 64, biggest 480 MB
application started analayze files and then return exeption

test 2
total number of log files added = 30 and I excluded 480 mb log file ,
range 2006/07/18 00:00 to 2006/07/18 16:00
application analyzed logs and active log(600MB) ,took about 25 minutes
to compete and I got window with all records modified.

1. Is any limit to number of log files that could be analyzed ?
2. user infromation shows only dbo , I guess the is no info about host name ,nt name available in log files?

[Brian Donahue]

Hi Alex,

I'm not aware of any hard-coded limit on the number of log backups that you can include in the log anaylsis, please correct me if I'm wrong.

If anything bad happens, it's probably because you don't have enough resources available (RAM, disk space...). Log Rescue can pound your local disk caching extracted information from the log file and/or backup files.

There's a funny issue to do with usernames in the SQL Server logs. Sometimes the username is not recorded, in these cases, log rescue calls the user unrecorded because the log identifies him with a userid of -1. For users that can be resolved to a user name, Log Rescue identifies any user that is part of the db_owner role as DBO. Otherwise, normal SQL users are listed in the analysis.

I hope this helps!
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521