Hi Rudy,

Thank you for the script. Lots of really great information.

I did notice one thing when examining the messages output. The name and version are reversed.

Detection of Production Name...

SQL Saturday in Cambridge, MA 2015 and 2014. 25 miles. I take the train because driving in Boston is something I like to avoid.

Also Code Camps in New Hampshire, probably...

homebrew01 (7/22/2016)

---

Thanks for the replies. I know the SP is hitting the correct database, because it completes 1 of the inserts correctly, but just "stops" at the next one.

All I...

cunningham (12/19/2012)

---

Thanks for this, put me on the right track. but I had to change the database in the drop down to MSDB rather than master or any other. my...

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...