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);
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
Post a Comment