Manic Star (4/19/2016)

---

VEEAM doesn't...

Thanks Jeff. I had seen a couple mentions of problems with AlwaysOn. We're not using AlwaysOn yet but it's one more thing to be concerned about.

Tony++ (2/12/2016)

---

You said April 12, 2016 as a date to be out of compliance, but didn't give any details on what makes that date important.

Can you share more info &...

I read this the same way as a lot of others. I wouldn't set up transaction logs to go from midnight until 8:00 pm but I've learned not to read...

When I first found that I started looking at what backups SQL Server had in msdb using this script (I don't remember where I got the base script from so...

Thanks Steve. This is exactly what I needed to know. As long as my full backup is still useful for a restore, I'm happy.

I did not find any evidence of...

Thanks Prett. I'm glad that my understanding of this aligns with the experts.

I now have the backup I need to take to the networking team.

Thanks Steve. Much appreciated.

Thanks Gail. I appreciate hearing from your experience on this.

All of our SQL Servers are on VMs except one. That one will be moved over to a VM this year and the box retired.

Hi Tim,

I added a check to your code to skip off-line databases. Here is the original section of code:

--Begin our maintenance tasks.

DECLARE curDatabase CURSOR FOR

--This statement filters out system databases...

Thanks Howard. I should have thought of that. Appreciate the help.

Thanks all. I know it's not useful for anything other than a teaching tool. I was hoping to get to the execution of the dynamic SQL mess at the end...