Go ahead. A google search will bring you the results you are looking for.

I can't recommend Veeam for SQL Server backups.

Our issue is that NSLOOKUP for AG Listener Name (ZZZDBAG) returns one IP address, sometimes two, and sometimes nothing, which is unusual. Is it supposed to return only one...

google is your friend. There are heaps of sites about alerting and how to set it up.

The problem is not solved, if...

• This reply was modified 1 year, 4 months ago by  deubel_m.
• This reply was modified 1 year, 4 months ago by  deubel_m.
• This reply was modified 1 year, 4 months ago by  deubel_m.

Hi Andreas,

how large is the sysjobhistory? Can you manually rebuild the index?

You should change that immediatly.

After you shrunk the logfile set an appropriate initial...

Of course it will work. Put your database in simple mode, shrink your log file and go on. That's my daily work, works always and that's the way...

Of course it will work. Put your database in simple mode, shrink your log...

• This reply was modified 1 year, 7 months ago by  deubel_m.

1. to run SSMS you don't need any admin permissions,
2. your user just need the sysadmin role,
3. to restart the services remotely your user need local admin permissions on the...

@datkop Hiho, you missed one important point. You didn't shrink your transaction log file.  After that continue to backup the transaction log and check if your log still...

If you have to set anything like encrypt=false or TrustServerCertificate=True to get you app working, your sql server is definitly configured to use a certificate. Maybe it's not set to...

No need for a large sql statement. Just open the properties of the job and check which database is uses. Easy peasy.

Hello @bobrooney.81

the solution to your problem is quite easy: Start thinking by your self. Then switch to https://ola.hallengren.com. There you find every necessary information about your problem.

But hey:...

Hello Chitown,

1. look at the SQL Server Errorlog,

2. look at the Windows Eventlog,

3. look at the application server and the application itself.

4. Execute (if possible) the statement of the job...