How to Shrink SQL Server database log files?

Huisheng Chen

0.00/5 (No votes)

8 Feb 2010CPOL

9.7K

DUMP TRANSACTION FooDB WITH NO_LOGBACKUP LOG FooDB WITH NO_LOGDBCC SHRINKDATABASE(FooDB)EXEC sp_dboption 'FooDB', 'autoshrink', 'TRUE'

SQL

DUMP  TRANSACTION  FooDB  WITH  NO_LOG
BACKUP LOG FooDB WITH NO_LOG
DBCC SHRINKDATABASE(FooDB)
EXEC sp_dboption 'FooDB', 'autoshrink', 'TRUE'

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)