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:...

Hi,

please check the sql server errorlog. Or check the windows eventlog. If a service is not able to start, there should be some entry in the logfiles.

Kind regards,

Andreas

Hi,

we are not able to look at your data. How big is your database, how much rows has your table?

What kind of stored procedure are you using?

If your stored procedure...

Hm,

this would not be easy. If you try an in-place upgrade, you are not able to fallback is something happens.

You could split your cluster to 2 single nodes, update the...

Hi,

maybe this script could tell you, which file group is full:

SELECT DB_NAME() AS DbName, 
name AS FileName, 
size/128.0 AS CurrentSizeMB, 
size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0 AS...

Hi,

sometimes, if you work with SSRS, you can get the double hop problem.

What kind of authorization are you using, NTLM or Kerberos?

And did this behavior will change, if you...

Hi,

it depends, did you an inplace upgrade?

What else has changed during upgrade?

Kind regards,

Andreas

Hi,

what are the main waits stats if you are testing with many users?

And what is your Max Degree for Parallelism and Cost Threshold for Parallelism.

Maybe your SQL Server won't work...

Hi,

and if can't do Log-Backups, your transactionlog will growth, it depends on your application, if you are able to handle this in one hour.

Kind regards,

Andreas

Hi,

what kind of tool do you use to check, if the database in part of the aoag?

Dashboard?

Scripts?

Take a lock at the Database on the primary and secondary, and lets us...

Hi,

if you got this error next time, just take a look at this query:

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

Hi,

you had to watch on the restore process, to put the database in the correct Recovery state:

1. Restore FULL Backup with "RESTORE WITH NORECOVERY"
2. Restore LOG Backup with "RESTORE WITH...

Hi,

we don't know your database mail configuration, and we don't know your smtp server configuration.

Is there a firewall between the sql server and the e-mail server?

Are you able to test...

Hi,

yes of course, you should use two different server and everything is fine.

kind regards,

Andreas