MSSQL: Shrink LDF

 MSSQL: Shrink LDF


Shrink LDF

1) <Pick database> => Properties => Options tab => Recovery Model => verify Simple 

2) SELECT logName  FROM sys.database_files WHERE type_desc = 'LOG';

3) DBCC SHRINKFILE (N'logName', 512);


Comments

Popular posts from this blog

GHL Email Campaigns

Free AI Tools

Await