The code will not work on a cluster unless you run it from the node(s) and not from the virtual SQL server.

Give it a try and let us know.

Rudy

Nice addition 🙂 My original version had SQL server version but I collect that information with another script so I removed it.

Glad to see that other find the code useful.

Rudy

I had the same problem found a fix that worked.

Execute the T-SQL code below on a working servers. It doesn't matter if it's production, development or UAT server since the...

Hello and Happy New Year to everyone 🙂

I have just tested this process on a SQL 2008 SP2 (x32 and x64) and it does work.

You can also add a...

Fix or not to fix? I say fix.

Why did Microsoft give us this function and then not fix it. How long has this problem been around? Sure give us BI...

Nicely done article.

I've spent some time on transaction log reading and found that author Kevvie Fowler's book "SQL Server Forensic Analysis" is great. He explains it in great detail. But...

Julien Chappel,

I'm guessing that you are referring to me when you say "To SSC Veteran".

I'll keep my comments short.

1) My name is not "To SSC Veteran" unless you are directing...

Good points Patrick

No thanks needed as I'm not defending anyone. One thing I don't mention is that when submitting code the author should do his/her best to ensure that it is working.

Now...

Thanks for the code! I've been using a script created by Gregory A. Larsen which I have modified to better suite my needs.

As for "buggy" code. Sometime we write...

John,

Good idea! Do you think we can all see this code of your? Originally, I did not include service accounts before we have a separate network for our production and...

Good idea about looking at all the instances. When I wrote this code, I was using it as a subset for another code that would allow me to collect all...

Thanks for the update.

Do you know if this change will work on SQL 2005 installation? i don't think this will. Guess there may need to be a version of SQL...

I hope to bring more utilities soon.

Thanks for your comments

Thanks for your comment.

Look forward to my new article (soon) that uses this script and others to help you reconstruct a SQL server that is dead.

Rudy 🙂