Tag Archives: sql

How to shrink SQL log files

ALTER DATABASE <db name> SET RECOVERY SIMPLE
DBCC SHRINKFILE(dblognamenotpath_log)
ALTER DATABASE <db name> SET RECOVERY FULL

db log name is from db properties – it is not path and not file name

or run full SQL backup

run SQL T log backup

How to shrink SQL log files

ALTER DATABASE <db name> SET RECOVERY SIMPLE
DBCC SHRINKFILE(dblognamenotpath_log)
ALTER DATABASE <db name> SET RECOVERY FULL

db log name is from db properties – it is not path and not file name

or run full SQL backup

run SQL T log backup