Hi,

we use about 150 SQL Server and we do every update automatic. Every SQL server got a maintenance windows, and got his patches, cu and updates without any manuell work.

We...

Hm,

it would be nice, if the creator of a question will give some feedback.

Nobody knows if the solution fixed your problem.

Hi,

I think it should start on the primary, you can use this script:

-- YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.

:Connect PRIMARY_SQL_Server

:Connect SECONDARY_SQL_Server

ALTER AVAILABILITY GROUP [YOU_AOAG_GROUP_NAME]...

Hi,

do you use a CMS, or are these sql servers only stand alone?

If you use a CMS, just script your changes on the first sql server, and deploy the changes...

Hi,

just disable xp_cmdshell and you will see, wich Job oder SP will end with an error. Otherwise you have to study the code of the Job and Stored Procedures.

Or you...

Hi,

I am confused, do you like to know how you prepare for the exam, or do you like the answer to the question number 12?

Kind regards,

Andreas

Hi,

maybe this link can help you:

https://techcommunity.microsoft.com/t5/sql-server/how-to-create-multiple-listeners-for-same-availability-group/ba-p/384028

Kind regards,

Andreas

Hi,

I got the sam error a view years ago. There was not enough memory for the operation system, to accept a new connection.

It was difficult to find, but easy to...

Hi,

theres are differences between an CU and a GDR update. But I don't know, how you can fix it. But if you once install a GDR update, no CU update...

Hi,

okay, than just take a look at the link to dbatools. It is quite simple and nice to use.

We do a lot of maintenance and work with this scripts.

good luck,

Andreas

Hi,

I don't think, that you have to remove a database from the AOAG to do some updates.

If so, you can take a look to dbatools, there are very good scriptes,...

Hi,

I think this is the same topic:

https://docs.microsoft.com/en-us/answers/questions/265195/cannot-bulk-load-because-the-file-could-not-be-ope.html

Maybe a kerberos problem with a double hop, or the service account got no permission on the file.

Kind regards,

Andreas

Hi,

it is always a good idea to install the updates. Be sure, to install them in your test environment first, and than bringt them to production, if they run fine...

Hi,

is the client and the sql server in the same domain?

Can you try to login from your client with a local sql login?

Are there are more entries in the sql...

Hi,

you should take your backup withour removing a database from your aoag.

Take a look at your configuration, maybe it is possible to take the backup from the secondary node.

Kind regards,

Andreas

PS:...