Viewing 15 posts - 61 through 75 (of 381 total)
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...
April 8, 2022 at 1:19 pm
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...
April 8, 2022 at 11:27 am
Hi,
no, do not change the user on the primary.
If this would be my own sql server, I would walk trought this steps.
2. create...
March 24, 2022 at 10:31 am
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
March 24, 2022 at 9:17 am
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
March 22, 2022 at 11:50 am
Hi,
have you checked, if your profile is "public" or "private"?
And is there an default profile?
Kind regards,
Andreas
March 22, 2022 at 11:43 am
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
February 22, 2022 at 7:14 am
Hi,
if your sql server and your workstation are in different domains, you may start your powershell with a run as command.
runas /netonly /user:your_domain\your_user path to powershell
Your are not able to...
January 7, 2022 at 12:10 pm
Hi,
try this link, maybe there are some usefull information for you:
https://docs.microsoft.com/en-us/answers/questions/662469/log4j-vulnerability-concerns.html
Kind regards,
Andreas
PS: sorry, I should read your topic until the end, there is the same link like in...
December 15, 2021 at 8:43 am
Hi,
have you checked your cluster error log?
I think there should be some usefull information.
Kind regards,
Andreas
November 26, 2021 at 7:32 am
Hi,
you should take a look at this parameters:
Cost Threshold for Parallelism
Max Degree of Parallelism
With these parameters, you are able to tell the sql server, how many of your cpu the...
November 26, 2021 at 7:30 am
Hi,
please choose different times for your backups. On our backups with a snapshot of VM, your database were "frozen" for some seconds. If this appears in the night, nobody cares.
But...
November 12, 2021 at 12:16 pm
Hi,
have you changed the connection string at your application?
I think, this would only work, if you aoag is ready for read only, and if the connection string got the following...
November 12, 2021 at 12:13 pm
Hi,
if you like powershell, take a look at this page:
https://docs.dbatools.io/Backup-DbaDatabase
It is quite simple and easy to use. Just build your script and use the windows scheduler.
Kind regards,
Andreas
November 12, 2021 at 12:09 pm
Hi,
are you able to ping the listener name from your workstation. If the listner is correct in the AOAG, maybe there are some error in the AD or in your...
October 29, 2021 at 8:26 am
Viewing 15 posts - 61 through 75 (of 381 total)