Click here to monitor SSC

Helen Joyce

Project Manager - Red Gate Software

Keep Log Shipping in shape

Published Tuesday, July 10, 2007 10:15 AM

The Log Shipping Monitor is an unsupported, free product available on the Red Gate Labs. If you are running log shipping jobs between servers you can now set up this application to collate the log shipping activity.  A summary is presented and graphs are plotted to look how the size of the backup files are changing over time and how long the backups have been taking.

 

If the duration of your transaction log backups is increasing steadily over time you are able to take a decision before the backups start failing. Take proactive action to reduce the size of the log, change the schedule of how regularly you perform backups or altering your backup statements in order to try and speed up the backup. The same applies to the size of the transaction log backup files. If you are able to spot patterns of behaviour you are able to be efficient about your log shipping strategy and therefore increase your confidence that it will continue to run successfully. The alerts functionality allow you to customise alerts for a variety of variables which helps you to be quick off the mark in spotting hazards or allow you to troubleshoot a problem soon after it’s happened to get the log shipping jobs back on track.

 

We want to know what you think. What’s your wish list for this application?

Post on the forum and get your opinions heard…your wishes may come true (plus you qualify to get Red Gate goodies).

Comments

No Comments
You need to sign in to comment on this blog
<July 2007>
SuMoTuWeThFrSa
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234
How to Kill a Company in One Step or Save it in Three
 The majority of companies that suffer a major data loss subsequently go out of business. Wesley David... Read more...

Migrating from OCS 2007 R2 to Lync: Part 4
 Having migrated the rest of our users and legacy resources across and started getting ready to... Read more...

Automated Script-generation with Powershell and SMO
 In the first of a series of articles on automating the process of building, modifying and copying SQL... Read more...

Seth Godin: Big in the IT Business
 Seth Godin has transformed our understanding of marketing in IT. He invented the concept of 'permission... Read more...

Using SQL Test Database Unit Testing with TeamCity Continuous Integration
 With database applications, the process of test and integration can be frustratingly slow because so... Read more...