I'm having a couple problems.
jkz999 wrote:1. I cannot see any restore history, the chart says No data to display. Is this because my monitor server is not on my production server?
petey wrote:Re 1:
You need to link a SQL Server agent job and job step to the standby server. This is because SQL Server does not store the duration of restores in the backup history tables. Hence the information needs to come from the SQL Server Agent job step.
I'm having problems with this as well. I'm not quite following your suggestion. Our setup does not include a monitoring server.
Per the documentation on the wiki, I'm supposed to select a job for the standby database so that the restore duration data can be filled in. When I select the ... button, I can see the jobs on the server, but I am unable to select any (or is the job field ever enabled)?
The backup duration is displayed properly.
2. I cannot get the freespace alerts to work on either server. I purposely specified 1 gig so that both would immediately get triggered. The commands were accepted and saved correctly, but they don't appear to work - meaning no alerts are triggered?
3. Since I'm at it......... I'll add something else for future enhancements.
When your adding alerts, it would be nice to not keep up with all the keywords. Granted, they aren't hard or anything, but it would be nice to eliminate the need to know them (esp. if more are added in future updates). So I propose, you add functionality that would add the alerts for the user when he/she right clicks in the alerts area or clicks an Add/Delete button.
In the case if you right click, you would have a menu such as:
Last restore, etc (format how you want).
So, the user right clicks and selects free space - the app should bring up a small dialog with a text box for the drive letter and a text box for the size.
Press ok or enter button and the command properly formatted is added for the user.
Pressing a different menu option would show different options required for setting up that alert. Pressing ok/enter - automatically puts the alert in the alerts box formatted correctly.
4. One more thing.................honest.....
Would it be possible to get data on the copy job? As duration, success/failures? I'm assuming you could use the log_shipping_monitor_history_detail table for this info?
Not sure if there's room on the summary page for it, or maybe add something (another tab, button) for viewing extended data.
5. Petty change request: Add an X to close the groups tab. Add a view menu or File menu option to view the tab again. In our case, we only have 1 group for log shipping. It would be nice to get the extra screen space. You guys did a nice job of the UI on the right side, so it's still easy to navigate the servers without need the tree view on the left (in this type of setup).