Menghapus (Shrinkfile) LOG dalam database

Posted on by
USE NAMADATABASE;
GO
DBCC SHRINKFILE (NAMADATABASE_LOG,1)
BACKUP LOG NAMADATABASE WITH TRUNCATE_ONLY
DBCC SHRINKFILE (NAMADATABASE_LOG,1)
GO

Leave a Reply

Your email address will not be published. Required fields are marked *