Download: Download snippet as printcmd_database_backup_log_truncate_shrink.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!
select 'use ['+db_name()+']' as cmd union all select 'checkpoint' as cmd union all select 'backup log '+db_name()+' with truncate_only' as cmd union all select 'dbcc shrinkfile('''+rtrim(name)+''',0)' as cmd from sysfiles where groupid <> 0 union all select 'dbcc shrinkfile('''+rtrim(name)+''',0)' as cmd from sysfiles where groupid = 0
Create a free my code stock.com account now.
my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!Find out more and register now
You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.