SQL and Sharepoint databases on one server
I need to do log backups of the SQL databases, Sharepoint DBs require simple recovery. I tried to create separate jobs, but the Sharepoint DBs show up in the SQL server list checked and grayed-out so you can't deselect them. The job randomly fails or has "exceptions" due to the sharepoint stuff.
I'm also concerned that, if I ever have to restore a server it will fail for lack of the other server being associated with the same backup job being restored. But I figure I'll try to get the backup running succesfully before I test restoring a successful backup. Because that's how I roll.
Anyone seen similar, find solutions to the shared SQL server problem?