0 Comments
USE DB_name
GO
DBCC SHRINKFILE(LOG_name, 1)
BACKUP LOG DB_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE(LOG_name, 1)
GO
where
DB_name = Database name
LOG_name = Database log name
Was this answer helpful ?
Yes
(3)
/
No
(0)
USE DB_name
GO
DBCC SHRINKFILE(LOG_name, 1)
BACKUP LOG DB_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE(LOG_name, 1)
GO
where
DB_name = Database name
LOG_name = Database log name