Index was outside the bounds of the array
AlexG
Posts: 24
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
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
Comments
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?
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!