I appreciate the reply. Our server administrator is demanding that this be corrected. He believes everything SCOM tells him. I am not sure where start, do you...

Thank you!

Thanks for all the replies. I am going to throw this question out there.

If an auditor came to you and said "I need to see who has access to...

It would seem to me that with laws like Sarbanes-Oxley, that a lot of DBAs would be faced with providing information/reviews of who has access to the databases they administer...

Thanks a lot. I am going to check them out.

I appreciate the information. It all makes perfect sense. The very first log backup to apply is the one IMMEDIATELY following full database backup. The chain is...

Thank you. Is the following safe to assume?

All log files up to the point of the NEW FULL database backup are unusable and could be deleted. Even the...

Thanks for answering the question. I would like to run one more thing by you just to clear up something in my mind.

If we have log backups taken every...

It appears they were attempting to truncate the log on a failed script they wrote.

Is there a way to query SQL Server to verify all the log backups are available...

Thank you for the reply.

Let me throw another scenario. What if someone took an unscheduled LOG backup during that period.

Would that unscheduled log backup break the cycle?

Thanks, this will help me out.

I am surprised there is nothing similar to dbcc sqlperf('logspace') like a dbcc sqlperf('dataspace')

I am trying both these queries out, thank you.

It appears I have to run the first query individually for each database, unlike the dbcc sqlperf ('logspace') which gives all databases...

I have actually been arguing for more access for a long time now. I came real close about 3 months ago, but then he had 'change of mind'.

Hey thanks a lot! That gets me what I need to know to watch over the drives. I can at least see when disk space is getting low.

Unfortunately no I do not. Our server admin does not like to give any more permission than necessary. He feels sysadmin is enough and that it should be...