General Bloging

Development and Stuff

About the author

Author Name is someone.
E-mail me Send mail

Recent comments

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2010

Truncate log files 2005

I always for get how to do this, and the  have to look it up when the dev box runs out of disk space.

backup log DBName with truncate_only

dbcc shrinkfile (DBName_log, 1)

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Categories: SQL server
Posted by gurney on Tuesday, February 17, 2009 1:24 PM
Permalink | Comments (0) | Post RSSRSS comment feed

Related posts