development notes for my failing memory

Shawson's Code Blog

  • Home
  • 8 Week Game
    • Animation Class
    • Geometry Include
    • How I tackled Collision Detection
    • Input Manager
    • Level & Level Manager Classes
    • Particle Emitter
    • Resource Manager
    • Sound Manager
  • Links
  • Who Am I?
  • Dev Utilities
    • Useful .net Pages
    • Useful JQuery Plugins
  • Quick Ref
    • ASP.net REST Webservices
    • ListView using a DropDownList populated using code behind
    • Regular Expressions
    • Simple nested Repeater controls
« OS X commands
Helicon ISAPI Rewrite rules ignored – You must save the rewrite file with ANSI encoding- NOT UTF8!! »

SQL Server truncate log


The command line syntax for truncating the SQL log’s once they are full!

BACKUP <db_name> LOG  WITH TRUNCATE_ONLY
Bookmark

Add to Del.icio.us Add to digg Add to DotNetKicks Add to Facebook Add to Google Bookmarks Add to LinkedIn Add to reddit Add to Stumble Upon Add to Technorati Add to Tip'd Add to Twitter

Related posts:

  • Clear down transaction logs
  • Executing sql statements from the command line (SQL Server 2008 R2 Express)
  • Example update with left outer join in SQL Server
  • Setting up session state database on sql server
  • Assigning execute permissions to Stored procedure in bulk on sql server 2000

This entry was posted on May 11, 2009, 09:07 and is filed under SQL Server. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

  • Comments (0)
  1. No comments yet.
Cancel Reply
(will not be published)


Submit Comment
  • .net (86)
    Accessibility (4)
    Android Development (4)
    Batch Scripting (5)
    blogging (4)
    C#.net (39)
    Classic ASP (1)
    Command Line (1)
    Cross Browser Testing (1)
    CSS (16)
    design (5)
    E-Commerce (2)
    Email (2)
    Entity Framework (2)
    Flash (2)
    GDC – Austin '09 (1)
    HTML5 (14)
    IIS (17)
    iPhone (9)
    Javascript (34)
    jQuery (19)
    KnockoutJS (5)
    Linq (4)
    Mac OS X (3)
    MVC (5)
    mySQL (5)
    Networking (3)
    nodejs (1)
    Objective C (4)
    OO Design (4)
    php (8)
    Powershell (1)
    Processing (1)
    Regex (3)
    REST (2)
    Security (1)
    Sharepoint (1)
    SQL Server (25)
    Telerik SiteFinity CMS (2)
    Test Driven Development (2)
    Umbraco (3)
    Uncategorized (4)
    URL Rewriting (3)
    vb (1)
    VB.net (9)
    VBScript (1)
    Video (1)
    Visual Studio (2)
    WCF (7)
    Web Services (10)
    Web Standards (3)
    WebGL (2)
    Windows (7)
    XHTML (6)
    XML (5)
    XNA Game Development (2)
    XPath (3)
    XSLT (1)

    WP Cumulus Flash tag cloud by Roy Tanck and Luke Morton requires Flash Player 9 or better.

  • Search

  •  

    May 2012
    M T W T F S S
    « Apr    
     123456
    78910111213
    14151617181920
    21222324252627
    28293031  
  • Archives

    • May 2012 (1)
    • April 2012 (1)
    • March 2012 (2)
    • February 2012 (1)
    • January 2012 (3)
    • December 2011 (1)
    • November 2011 (5)
    • October 2011 (2)
    • September 2011 (7)
    • August 2011 (7)
    • July 2011 (7)
    • June 2011 (2)
    • May 2011 (3)
    • April 2011 (1)
    • March 2011 (2)
    • February 2011 (5)
    • January 2011 (7)
    • December 2010 (4)
    • November 2010 (5)
    • October 2010 (6)
    • September 2010 (10)
    • August 2010 (6)
    • July 2010 (6)
    • June 2010 (9)
    • May 2010 (8)
    • April 2010 (3)
    • March 2010 (2)
    • February 2010 (4)
    • January 2010 (6)
    • December 2009 (6)
    • November 2009 (1)
    • October 2009 (6)
    • September 2009 (3)
    • August 2009 (8)
    • July 2009 (15)
    • June 2009 (5)
    • May 2009 (9)
    • April 2009 (11)
    • March 2009 (3)
    • February 2009 (1)
    • January 2009 (3)
    • December 2008 (3)
    • November 2008 (4)
    • October 2008 (11)
  • Colleagues Blogs

    • Allan Wenham
    • Andrew Heasman
    • Dave Child
    • Dom Edwards
    • Gareth Bradley
    • Martin Elsworth
    • Natasha Hampshire
    • Paul Ledger
    • Sam Langdon
  • Industry Sites

    • IPhone Code Masters
    • YouLove.Us
  • My Other Sites

    • 8 week game competition
    • My iPhone Apps
    • My Travel Blog
    • Shawson.co.uk
  • Other Dev Blogs

    • Heather Solomon – Sharepoint
    • Jeff Lemarche – iPhone
    • Nicholas Zakas – Javascript
    • Scott Gutherie – .net
    • Scott Millett – asp.net
    • Tim Geyssens – Umbraco
  • Past Work

    • Aerco
    • Amerang Models
    • Apuldram Roses
    • Beast Quest
    • Brighton Institute of Modern Music
    • Certikin
    • Crickmay
    • Franklin Watts
    • Hodder Childrens Books
    • moneybarn.com
    • Orchard Childrens Books
    • The Beauty Room
    • Tiara Club
    • Wineware
  • Useful Sites

    • A List Apart
    • Cre8asite Forums
    • Dig Web Interface
    • NeHe OpenGL Game Tutorials
    • Shawson.co.uk Root
    • Smashing Magazine
    • Snipplr Code Snippets
    • Visual JQuery Dictionary
  • RSS Flexicoder Blog

    • WWDC 2012 – Apple TV Apps May 10, 2012
      I’m lucky enough to be attending the WWDC this year, as it reaches closer to the “day of the long queue” my thoughts are turning to what I hope will be announced at the conference. So here they are in no real order (apart from the first one) Ability to run apps on the Apple […]
    • Úll Conference – Review May 1, 2012
      I’ve just come back from Dublin, Ireland, where I attended the Úll Conference to cover all things iOS related. When the tickets where first released, the conference was advertised as a 3 day affair, starting on Friday 27th April and ending on the Sunday. A friend from Ireland, @realmikebutler, had told me about the conference […]
    • Worthing Digital – Local Tech Community March 8, 2012
      If you are local to the Worthing/Sussex area, please check out the new Worthing Digital group, they’ve arranged a number of good talks and also started up a co-working event. If you have any ideas on helping the community grow you can also post comments on the forum […]
    • Open doors effect at App launch February 4, 2012
      This is a copy of a blog entry I originally wrote for ios-blog There are a number of apps in the App Store that launch with a set of closed doors, these are then opened to present the actual UI underneath it. I had to create this effect for an app I wrote for a […]
    • New App – Ballpark Costs January 26, 2012
      When potential clients ask for a ballpark figure on development costs, these are the questions I ask to help clarify whats required and therefore affect the cost. They are in no particular order… What are the target platforms, iPhone, iPad, Android, Windows Mobile? If iPhone do you want a universal version, i.e. the same app […]
    • CCLabelBMFont – not displaying May 13, 2011
      I hit a problem today where the CCLabelBMFont wasn’t rendering the text I wanted at all. I created the the fnt file using http://www.n4te.com/hiero/hiero.jnlp Turns out that as it creates the underlying png for some reason it saves it in a flipped format, therefore you need to load the png into your favourite graphics package […]

Fusion theme by digitalnature | powered by WordPress
Entries (RSS) and Comments (RSS) ^

SetTextSize SetPageWidth