SQL Server clears database log scripts

SQL Server clears database log scripts

To clear the code for the MSSQL database log:

Use master
Go

DECLARE @dbname varchar (50)
Declare temp_cur cursor scroll for select name from sysdatabases
Open Temp_cur
Fetch the temp_cur into @dbname
While @ @fetch_status =0
Begin
EXEC (' backup log [' + @dbname + '] with no_log ')
EXEC (' DBCC SHRINKDATABASE ([' + @dbname + ']) ')
EXEC (' DBCC CHECKCATALOG ([' + @dbname + ']) ')
EXEC (' Dump TRANSACTION [' + @dbname + '] with no_log ')
FETCH NEXT from Temp_cur into @dbname
End
Close Temp_cur
Deallocate temp_cur