I suggest to read transaction log management.

select log_reuse_wait_desc from sys.databases where name='name'

state 1 - LOG_BACKUP

This the above always shows log backup. If yes, you need to increase the t-log backup frequency, like every 15 minutes.

Review all...

Have you configured transaction log backup? How frequent you are running?

Yes, use domain account, you will have a more control.

Better to wait until in recovery finish.

I have faced same issue many times. Even row versioning enabled for the database which prevent the TempDB shrinking.

https://www.sqlserverblogforum.com/dba/tempdb-database-is-full/

Is there a way to get the list of databases from all sql server instances in the network?  Lets say if we have 30 instances rather than getting the...

I am using SQL server 2017 standand edition. We installed on a virtual machine.

A question about SQL license:

If the VM has assigned 2 CPU (sockets) and each one has...

Hi

This is when you are migrating from old server to new server.

Is it better to script out the logins and run the login script on new server?

OR

Use sp_help_revlogin and...

Start collect the perfmon and in parallel run something like server side trace, whoisactive or extended events. You can compare the code run when you have high cpu or iops.

Query...

SA is the sysadmin...

You can write SP by linked server to disable from one server. OR

use this in fly dynamic script

SELECT 'Exec msdb.dbo.sp_update_alert @name='''+name+''',@enabled=0'FROM msdb.dbo.sysalertsWHERE enabled =1

Then you need to disable those alert in SSMS before doing any activity.

Hello,

We had some sql server have issues on some production servers.  We actually didn't know about some situations until users emailed us with issues.  Therefore, our DBA team decided...

It depends on the business, mostly as quick as possible.