Snap on Code | Can automate shrinking MS SQL log files?

Shorten your application development with snap on code

RSS Feed

Pages

About Snap on Code

Archive

2009
- November (17)
- December (7)
2010
- March (2)
- April (1)
- June (2)
- July (2)

Calender

Blogroll

Recent posts

How to redirect from asp.net login controlNot rated yet
How to get DataKeyNames from GridView with select option and RowCommandRating: 5 / 1
Display image in asp.net GridViewNot rated yet
Upload image to ms sql database using sqldatasource1Not rated yet
How to add javascript to asp.net textbox controlNot rated yet
How to change the create user wizard membership role default provider connection stringNot rated yet
How to change the create user wizard membership default provider connection stringNot rated yet
Visual studio 2008 wont run web page in the IIS Development Server.Not rated yet
Working with Report Viewer, RDLC files and Sub reportsRating: 3.6 / 5
Capture the DataGridView Button Column Click EventRating: 5 / 1

Recent comments

None

<< Getting record Identity with sql and oledb | SQL Statements for MS Access 2007 >>

Can automate shrinking MS SQL log files?

mark ,27. November 2009, 07:01

declare @dbname nvarchar(255)
set @dbname = ‘yourdatabasenamehere’
backup log @dbname with truncate_only
DBCC SHRINKDATABASE (@dbname, 0)

f55458ca-aed6-43d8-92a3-32c079d04801|2|5.0

Tags:
Category: MS SQL

E-mail | Permalink | Comments (0) | Trackback

Related posts

MySQL Log MaintenanceServer Log Maintenance A log flushing operation does the following: If general query logging (--l...Upload image to ms sql database using sqldatasource1Upload image to ms sql database using sqldatasource1Concat columns with sql in ms accessConcat columns with sql in ms access