Clear System log and database (SQL Server) log best practices

Problems encountered in a project: The system log is too large, and later deleted with the DELETE statement (rather slow), the results of the database log becomes very large (almost 10G), so you have to delete the database log.

Method:

--partial logs in the backup system
--select * into #keep from Ccssystemlog WHERE logtime > ' 2011-12-31 '
--truncate TABLE Ccssystemlog
--insert ccssystemlog SELECT * from #keep
--drop Table #keep

--Clear the database log (you can also use the database detach--delete log---> Append data method)
--dump TRANSACTION database name with no_log;
--DBCC shrinkfile (' Database name _log ', 1);

--This sentence is shrinking data files and log files
--DBCC shrinkdatabase (database name)

Clear System log and database (SQL Server) log best practices