Arise Software Ltd

Support and Help Docs

2. April 2019 12:41
by Admin
0 Comments

Large Database Size

2. April 2019 12:41 by Admin | 0 Comments

Microsoft records all activity in the LDF file and can get large. The activities can be removed although we then cannot do database audit forensics on it later, if ever required. To empty the LDF file via sql server management studio, query analyser

USE master

ALTER DATABASE gdpro SET RECOVERY SIMPLE WITH NO_WAIT

use gdpro

DBCC SHRINKFILE(gdpro_log, 1)

USE master

ALTER DATABASE gdpro SET RECOVERY FULL WITH NO_WAIT

Comments are closed