CodePaste.NET - Truncate & shrink sql db

Subscribe

Discuss

What's new

What is it

New Snippet

Recent Snippets

Recent Snippets

My Snippets

My Snippets

Web Code

Search Snippets

Search

Sign inor Register

Language: SQL

Truncate & shrink sql db

254 Views

Copy Code

Show/Hide Line Numbers

 
backup log <Database_Name, sysname, Database_Name> with truncate_only
go
use <Database_Name, sysname, Database_Name>
go
dbcc shrinkfile (<Database_Name, sysname, Database_Name>_log,  2)
go
 
DBCC SHRINKDATABASE(N'<Database_Name, sysname, Database_Name>' )

by Tareq
April 10, 2010 @ 2:03am

Tags:

Truncate, shrink, sql

Description:

SQL server template to truncate the log file and shrink the database

Add a comment

Report Abuse

brought to you by:

West Wind Techologies

If you find this site useful and use it frequently please consider making a donation to support this free service.

Donate