Log shipping itself will work. However, I am not sure Sharepoint will be able to use the database on the secondary server since SQL Server instance names are likely to be embedded in all sorts of places both in the database and probably in registry or sharepoint config file.