Red Gate forums :: View topic - SQL Log Rescue Annoyances
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

SQL Log Rescue Annoyances

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
mglenn



Joined: 13 Sep 2006
Posts: 16

PostPosted: Fri Sep 15, 2006 11:13 pm    Post subject: SQL Log Rescue Annoyances Reply with quote

I recently started working with Log Rescue so some of this could be "user error", but:

1. During install you can choose to install extended stored procs on the default instance or not, but you can't specify a named instance during install (have to do that later).

2. Poor support for analyzing isolated log files. It might help to have more separation between analysis and recovery modes so users can analyze without having to meet the criteria necessary for successful recovery (such as access to the full backup, no missing logs, etc.).

3. Saving a project doesn't buy you much during the most labor intensive step--Choose Database Backups--because it ignores your saved choices and forces you to select files all over again when opening an existing project. (Not such a big deal unless you do frequent transaction log backups.)

Let me know if any of this is user error!
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Sat Sep 16, 2006 12:19 pm    Post subject: Reply with quote

Hi Mike,

Log Rescue may ask you to install the extended stored procedure, but it also very cleverly installs the XP automatically on the server when you choose to analyze a database on that server.

It's not designed specifically as an analysis/auditing tool, so it does have a shortcoming in that it can't simply dump a list of transactions from the log file. In order to fulfill the role of 'undo for SQL Server', it needs to know about the state of the schema and other things before it can proceed to geterate undo/redo scripts for the changes in the data that happen inside the log. This also results in some lengthy processing times before you can begin to work with the transactions in the log file.

Probably the project management could use some enhancement. I haven't got any suggestions for you in that area.
Back to top
View user's profile Send private message
mglenn



Joined: 13 Sep 2006
Posts: 16

PostPosted: Sun Sep 17, 2006 1:56 am    Post subject: Reply with quote

Log Rescue is a nice utility really. Just wanted to suggest some minor tweaks.

1. True. Maybe something as simple as a parenthetical statement added to the dialog box "(The extended stored procedure can easily be created for named instances after intallation is complete.)" would help. This would save new customers from needlessly looking around for ways to specify a named instance during install, searching through the help file and possibly even contacting support only to discover a short time later that it's not a problem.

2. I understand. Expanding analysis functionality would obviously increase the price as well and no one would be happy about that. Wink

3. Just retaining file selections in saved projects would be great.

Thanks for the quick response and taking time to discuss my feedback.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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