Amazed that I am still in mid 2025 getting this error on a 2019 version instance. Good to see some suggested solutions though. Community!

Nice!

Works lika a charm. Is there a place where I can find "all" other possible useraccountcontrol values, than those included in the script?

I have also these:

544

546

4096

16777728

16843264

included in this code...

Still in 2014 (SSDT-BI from Visual Studio 2013 probably is more accurate, but SQL Server 2014 is where I will be running it) you have to set it by marking...

First: It was a while ago someone posted in this thread, perhaps I should make a new one but anyways:

I'm having a problem reading active directory via linked server...

Thought so. It doesn't seem to change the result if I elaborate with changing the '9' to a '1', '0' or '77777' (or '*'). 🙂

That helps a lot on the backup side of my two questions. Thank you Brent.

Any one up for trying to answer the tx log question as well? Do I...

Thank you Brent. I actually read your blog post about rockstars yesterday and feel a bit like, I don't now, not really a rock star, but at least a fan,...

Old thread, but as a witness I must speak up :hehe:

If you just read the errata for the book, and the comments googled on the web and also in this...

That is for another error, not the "is stored on multiple volumes" error. Anyone got a hint on what to do?

I got a later version than that kb specifies and still have a problem with checkdb and same error.

Microsoft SQL Server 2005 - 9.00.3282.00 (X64) Aug ...