Sql Server Transaction Log File Is Not Shrinking

How To Enable Deadlock Trace in Sql Server

SQL Server Management Studio (SSMS) Keyboard Shortcuts

What is the difference between SQL Profiler vs Server side Trace

Server Side Trace vs Client Side Trace

How to restore system databases on lower build

knowledge sharing : Restoring System databases on different build

Issue :

Datafiles and log files are lost on Uat server  due to OS issue
------> Sql server is down
------> All data and log files lost including system database
------> Only backups are available

Database cannot be shrunk as it is either being shrunk by another process or is empty.

Hi, Today we faced below error on one of the servers while shrinking data file on user request.

Error :
/*************************************************************************************************/

File ID 1 of database ID 6 cannot be shrunk as it is either being shrunk by another process or is empty.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
/*************************************************************************************************/

What is the difference between Sql Server 2005 and 2008 patching

How Sql server Deadlock Mechanism works

Deadlock Detection

Note: To enable deadlock , Please refer : How To Enable Deadlock Trace in Sql Server

 Deadlock detection is performed by a lock monitor thread that periodically initiates a search through all of the tasks in an instance of the Database Engine. The following points describe the search process:

How to find Sql Server Port