All databases can be mirrored for high availability except:
WebAnalyticsServiceApplication_StagingDB_
User Profile Service Application_SyncDB_
User Profile Service Application_SocialDB_
FASTSearchAdminDatabase
Reporting Services databases.
The only databases that can be logged shipped or use async mirroring:
WSS_Content
WSS_UsageApplication (not recommended)
Secure_Store_Service_DB_
All ProjectServer DBs if all db logs are synched
DefaultPowerPivotServiceApplicationDB (SQL server only)
This is according to this TechNet article updated July 29, 2010.
Another TechNet article also updated July 29, 2010 indicates that the following databases can also be log shipped:
Application_Registry_server_DB_
Managed Metadata Service_
PerformancePoint Service Application_
WebAnalyticsServiceApplication_StagingDB_
WebAnalyticsServiceApplication_ReportingDB_
User Profile Service Application_SocialDB_
Technically, I would concur with extending this list to include these.
With thanks to C. Liu
