SCSM 2012 Data Warehouse DWDataMart Full

Recently i nearly got myself into a dead lock where my SCSM 2012 Data Warehouse Management Server goes dead as the disk space use up by the DWDataMart Log.

Since the backup of the database failed weeks ago and unfortunately no one noticing it, the DB log file grows to 23GB and immediately flood out the hard drive.

I soon come to a very useful SQL command which can truncate the DB Log. Also not that by doing this, you lost the recovery option of that period, so do think twice before using this command.

BACKUP LOG DWDataMart TO DISK = N'e:DWDataMart.bak'

GO

DBCC SHRINKFILE('SM_LOG', 1)

GO

This is a simple command that safe my day. :-)

You can also apply this to clean up the DWRepository as well in case the log use up all the space.