1 2 3 4 | ALTER DATABASE testdb SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(testdb, 1) DBCC SHRINKFILE(testdb_log, 1) ALTER DATABASE testdb SET RECOVERY FULL WITH NO_WAIT |
mssql log clear and shrink file
1 2 3 4 ALTER DATABA.
1 2 3 4 ALTER DATABA.
1 2 3 4 | ALTER DATABASE testdb SET RECOVERY SIMPLE WITH NO_WAIT DBCC SHRINKFILE(testdb, 1) DBCC SHRINKFILE(testdb_log, 1) ALTER DATABASE testdb SET RECOVERY FULL WITH NO_WAIT |