Hi,

just take a look, what is your logfile blocking from "shrinking"

SELECT
    name AS DatabaseName,
    log_reuse_wait_desc AS LogBlocking,
    recovery_model_desc...

Hi,

please post Code as Code should be postet.

It is quiet difficult to read.

USE msdb
GO
DBCC sqlperf (logspace)

This ist just am sample, how code should looks like.

Kind regards,

Andreas

Hi,

if you use a listener, I think you need a DNS server, because the IP from the listener will change to the active node if a failover occurs.

But we do...

Hello,

would you delete the rows in the database, or in the result set?

And, please avoid to post photos, use code instead.

Kind regards,

Andreas

Hi,

maybe you can use the sa user, only to kill your own admin account. After you removed your account, just disable the sa account for a better security.

kind regards,

Andreas

Hi,

we don't know how many rows you've got, but it is better, if you create an index after you put all the data in the table.

If your application will change...

Hi,

just add 1 step in your job, where you can check, if your node is currently the active node.

If so, just execute step nr.2, otherwise, quit the job.

Good luck,

Kind regards,

Andreas

Hi,

it is very diffucult to read the t-sql. Try to put your code in the right form

select @@version

It is very easy.

Hi,

on a failover Cluster, every node got a sql server Installation. If a failover occours  the Cluster Manager will Start the services.

There are patches wich are installed on the passive...

Hi,

are you talking about windows failover cluster, or about always on availibility groups?

These anwsers are for the fail over cluster, not for the aoag.

1)

standard edition is able to create a...

Hi,

no, do not change the user on the primary.

If this would be my own sql server, I would walk trought this steps.

1. drop the wrong user on the secondary

2.  create...

Hi,

I think, this won't work. Just drop the wrong user, and create the new user with the script and the right SID.

Kind regards,

Andreas

Hi,

take a look at this topic:

https://www.sqlservercentral.com/forums/topic/database-mail-not-working-after-sql-server-2016-sp3

Kind regards,

Andreas

Hi,

have you checked, if your profile is "public" or "private"?

And is there an default profile?

Kind regards,

Andreas

Hi,

are you able to send e-mail from the windows server with bmail?

I would try, if the problem is maybe the e-mailserver, or the ssrs.

https://github.com/RussellGrew/bmailv107

Good luck

Andreas