VerboseLogging = 0

SqlDumperDumpFlags = 0

SqlDumperDumpPath = ''

SqlDumpTimeOut = 0

SqlPreStatupActionsFlags = 0

FailureConditionLevel = 3

HealthCheckTimeout=60000

SqlDMVScriptTimeOut = 0

Yes the sub folder does have inheritance broken from the parent server. And the browser group for the parent folder has been removed. But the AD SG group in question...

Yes that was my first thought as well, getting pushback from my System Admin. Just need to make a good enough case to have this happen.

Wow that is alot of work

Why arent you using the SMO option. I have other options but I would suggest that you research what you need.

ScriptingOptions scropt = new...

The exact error was

Copy Data: Error: Table "[Schema].[TableName]" does not exist at the source.

Well this turned out to be a real error. Somebody had deleted the table. ...

Thanks for both of your help, I am going to look into the Event Notification

Thats exactly what it was. My sys admin remove the offending disks, since they where not even in use and the update ran fine.

Yes I see that now after running the tool. Thanks for the reply. We had a number of issues, 4 of the instances did not have SPN's and the service...

So I had a bunch of issues

1. I needed to add SPN to the MSSQLSvs\<ServerNode>.domain:<Instancename> to account <SQLSDE.ServiceAccount>

2. And the service accounts in question are marked Account is sensitive and...

Thanks for all of your help. We will see how it goes. I am meeting with the CIO and SAN/system admin today and see about getting a test servers

In a prefect world yes I would test it first in our test environment, except for the fact that they don't have a test environment. As for the backup I...

That is exactly the set up, and that is what I thought. Would I be able to update the passive instances during the workweek and then on the weekend fail...

Thanks for the reply. this is my first time working with clustered SQL server so I am a little lite on the terms. By active do you mean that both...

I have been in charge of small SQL shops <30dbs and <1 terabyte of info. I have been using Ola Hallengren backup scripts for about 4 years now backup up...

We found the issue. SQL could not delete the ERRORLOG file to create the new one on the SQL startup. We renamed the file and the SQL service started without...