--Note: Check is required if you want to remove log file. Only Secondary log file and data file can be removed.
checkpoint
go
USE [DB_Name]
GO
dbcc shrinkfile (DB_name_LOG_2, emptyfile)
go
ALTER DATABASE [DB_Name] REMOVE FILE [DB_Name_LOG_2]
GO
--Query to find missing index from query store, from last 30days usage SELECT TOP 20 qsq.query_id, SUM(qrs.count_executions) *...
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done,...
Comments