I have absolutly no idea what you are talking about. Running jobs in sql server agent does not require rdp sessions so far. Just a SSMS and the corresponding permissions....

Well a file share isn't shared storage. Just for the record. Obviously you want us to authorize you to remove it. Go ahead remove it and tell us what happend....

Another DBA mistakenly created a file share witness for one of our ao clusters. To make matters worse, it's pointed at a server we decommissioned. The cluster doesn't seem...

It's not that difficult. On the starting page of the dialog choose as server typ "SQL Server". Create a login on the remote sql server. On the Security Tab choose...

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 2 years, 1 month ago by deubel_m.
• This reply was modified 2 years, 1 month ago by deubel_m.
• This reply was modified 2 years, 1 month 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 2 years, 4 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 grows.