I have a client with a single server Windows Server 2012 Essentials domain and they need to run SQL Server 2012 on this machine. I know this is not recommended but is it possible?. The database is not heavily used as it only has three users.
When initially trying to do this I ran into errors
"the sql server 2012 service account is invalid on domain controller"
I tried changing the account to domain accounts with equivalent admin access but got the same errors.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed