I just submitted to Chris Fox for review and posting on the OpsManJam site, the guide "System Center Operations Manager 2007 Configure SQL Server Log Shipping Guide for Operations Manager 2007 Operational Database" that I have been working on in my spare time. This guide currently only covers the implementation of Log Shipping as an HA option for the OperationsManager (operational) database, not the Audit or Data Warehouse database, and provides guidance on configuring the secondary SQL Server and the management group when the primary SQL Server becomes unavailable. While I have reviewed similar documentation developed by others outside of Microsoft, I felt it necessary to ensure detailed guidance is consistant with our other published whitepapers. I am a stickler for consistency and detail, if you have not realized that already!
While I could have also covered the Data Warehouse and Audit database, it would have taken a bit more time and I felt I could add guidance for those two databases in a future version.
As soon as I see it published on the OpsManJam site, I'll post an update. However, I am sure you have RSS feeds enabled and will be notified accordingly.