Viewing 15 posts - 16 through 30 (of 322 total)
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
Hi,
are you able to ping the listener name from your workstation.
Is the IP from the listener in the same ip subnet, or a different one?
Are there firewalls in your network?
Are...
October 28, 2021 at 10:52 am
Hi,
have you ever tried to search for your issue?
https://qa.sqlservercentral.com/articles/how-to-setup-log-shipping-for-multiple-databases
good luck
Andreas
October 14, 2021 at 8:54 am
Hi,
how should someone know how much memory you will need.
What kind of application do you run against the database. Is a OLTP or an OLAP system?
Have you ever tried some...
October 5, 2021 at 8:01 am
Hi,
any ERRORLOGs, is the service running, are you able to ping this server, and are you able to check if the port is "open"?
There are a lot of possibilities to...
August 13, 2021 at 10:04 am
Hi,
is there an error, with what credentials do you start the setup?
Where is your default instance missing => Screenshot?
Kind regards,
Andreas
August 11, 2021 at 11:16 am
Hi,
maybe you can find these informations in the windows event viewer.
Just take a look at the "system" tab, and check the time fram, when the service was startet.
Good luck,
Andreas
August 11, 2021 at 11:15 am
Hi,
if the export job is running as an sql server agent job, the service user needs the permission to create the export file in the directory.
If you just run the...
August 10, 2021 at 10:44 am
Hi,
just use your database, and select:
Database Diagrams
Right click and create your own new diagram?
Good luck,
Andreas
August 10, 2021 at 10:40 am
Hi,
if there are no entrys, there are no reasons that should block the log backup. And if the log backup is running, you should be able to shrink your database.
But,...
August 2, 2021 at 11:33 am
Hi,
what is the output from the execution plan. We got a high cpu usage, because there was an explicit type conversion from nvarchar(4000) to char(29).
We were able to fix this,...
August 2, 2021 at 10:30 am
Hi,
have you checked if your transaction log is empty?
dbcc sqlperf (logspace)
If you log is empty enough, then you should able to shrink it.
Please check before, if it...
August 2, 2021 at 10:23 am
Hi,
there are a lot of solutions in the internet, if you try the google search.
Without a domain you had to use certificates:
https://www.programmersought.com/article/74244325570/
Andreas
June 16, 2021 at 8:59 am
Hi,
I think it depends on your workload. If you can cluster your database in meaningful ndf files, you can win some performance.
But it would not be the best practice to...
June 4, 2021 at 9:39 am
Hi,
we start every night a new ERRORLOG. It is very easy so find errors, but I think, it is not necessary.
Autogrowth,
hm, just check your settings, and take care, there are...
June 4, 2021 at 9:36 am
Viewing 15 posts - 16 through 30 (of 322 total)