Sharepoint 2010 Event Error 3760

Windows 2012 R2 Server
IIS 8.5
SharePoint 2010 Farm SP2
Windows 2008 R2 Server
SQL 2008

Today the problems continue with my User Profile Sync issues first the service is stuck in starting which I have open issue with

And now I am getting this error

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          7/20/2015 6:00:01 PM
Event ID:      3760
Task Category: Database
Level:         Critical
Keywords:      
User:          mydom\spfarm
Computer:      SERV013.FQDN.com
Description:
SQL Database 'User Profile Service Application_SyncDB_5d0b20605e2e425c865e67f0a826f73c' on SQL Server instance 'serv010\sharepoint' not found. Additional error information from SQL Server is included below.

Cannot open database "User Profile Service Application_SyncDB_5d0b20605e2e425c865e67f0a826f73c" requested by the login. The login failed.
Login failed for user 'mydom\spfarm'.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <EventID>3760</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2015-07-20T22:00:01.855769300Z" />
    <EventRecordID>34621</EventRecordID>
    <Correlation ActivityID="{5E22266C-69E8-4F06-B8AA-FFAA8477C320}" />
    <Execution ProcessID="6924" ThreadID="6000" />
    <Channel>Application</Channel>
    <Computer>SERV013.FQDN.com</Computer>
    <Security UserID="S-1-5-21-3054588571-1341459584-784128302-3142" />
  </System>
  <EventData>
    <Data Name="string0">User Profile Service Application_SyncDB_5d0b20605e2e425c865e67f0a826f73c</Data>
    <Data Name="string1">SERV010\sharepoint</Data>
    <Data Name="string2">Cannot open database "User Profile Service Application_SyncDB_5d0b20605e2e425c865e67f0a826f73c" requested by the login. The login failed.
Login failed for user 'mydom\spfarm'.</Data>
  </EventData>
</Event>


The database is online checked my SQL server

My research only found issue with the content database

How do I fix this?