sys.dm_server_services - How to check if SQL Server service is running or not?

How to check if SQL Server service is running or not?How to get service account details in SQL Server? Read more →

Msg 3023, Level 16, State 2 Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.

What is MSG 3023 Level 16 State 2 Line 4?, How to fix 3023 error in SQL Server? Read more →

Can we restore a database to an older version in SQL Server?

Can you restore a SQL 2017 database to SQL 2019?Can we restore SQL Server 2017 backup to 2016?How to restore SQL database to a lower version? Read more →

How do I save all SQL Agent Jobs

How do I export SQL Agent jobs? Read more →

How to view SQL Server mount point space without access to server

What does dir s do in CMD? How to get the SQL Server mount point size with dir /s Read more →

DBCC SHRINKFILE: page could not be moved because it is a work table page.

How to fix tempdb full issue in SQL Server?How do I clear tempdb space in SQL Server? Read more →

SQL Agent Last Modified explanation

When was my SQL Agent Job last modified ? Read more →