Red Gate forums :: View topic - Index was outside the bounds of the array
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

Index was outside the bounds of the array

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



Joined: 07 Apr 2006
Posts: 14

PostPosted: Tue Jul 18, 2006 10:57 pm    Post subject: Index was outside the bounds of the array Reply with quote

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
Back to top
View user's profile Send private message
AlexG



Joined: 07 Apr 2006
Posts: 14

PostPosted: Wed Jul 19, 2006 10:22 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Tue Jul 25, 2006 4:39 pm    Post subject: Reply with quote

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