I have a server running SQL Server 2005. I have nightly full backups, with transaction log backups every 15 minutes. This is a relatively small server so I am not doing any differential backups.
If one of the nightly full backups fails, is the database recoverable using the previous night's backup and all of the transaction logs for both days, or would there be a problem with the missing full backup?
My organization has been using Active Directory groups to handle permissions to simple business applications, folders, and SQL Server objects. A coworker has been suggesting that we use Microsoft's AZManager to handle this kind of thing, but I don't really understand what this tool does that AD groups do not and he isn't sure either.
I understand from the documentation that AZManager does integrate with AD, but is there anything that it offers that AD doesn't already do? Am I mistaken in thinking that we won't need it?