Notes for Configuring SQL Server 2005 database mirroring for SharePoint

You have to use synchronous mirroring for SharePoint's own databases (Sharepoint_admin, config vs.)

But you can use both async and sync for Content Databases.