notes:sql:shrinklog
Shrinking Log in SQL Server
CHECKPOINT EXEC sp_helpdb 'MyDatabase' DBCC SHRINKFILE(MyDatabase_log,10) BACKUP LOG MyDatabase WITH TRUNCATE_ONLY EXEC sp_helpdb 'MyDatabase'
notes/sql/shrinklog.txt · Last modified: 2020/08/26 (external edit)
