Viewing 15 posts - 61 through 75 (of 389 total)
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...
November 21, 2022 at 10:54 am
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
November 21, 2022 at 9:46 am
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...
November 4, 2022 at 7:40 am
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
October 10, 2022 at 6:04 am
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
September 29, 2022 at 5:08 am
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...
September 20, 2022 at 12:25 pm
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
September 20, 2022 at 12:18 pm
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.
April 14, 2022 at 6:37 am
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
Viewing 15 posts - 61 through 75 (of 389 total)