development notes for my failing memory

Shawson's Code Blog

  • Home
  • 8 Week Game
    • Animation Class
    • Geometry Include
    • How I tackled Collision Detection
    • Sound Manager
  • 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:

  • Setting up session state database on sql server
  • Example update with left outer join in SQL Server
  • Assigning execute permissions to Stored procedure in bulk on sql server 2000
  • Full Text Reindex, scheduled job has no steps!
  • Classic ASP SQL Injection vulnerability analyser

This entry was posted on Monday, May 11th, 2009 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)
  • Trackbacks (0)
  1. No comments yet.
Cancel Reply
(will not be published)
Submit Comment
  1. No trackbacks yet.
  • .net (59)
    Accessibility (3)
    Batch Scripting (3)
    blogging (4)
    C#.net (19)
    Classic ASP (1)
    Command Line (1)
    CSS (12)
    design (2)
    E-Commerce (2)
    Email (2)
    Flash (1)
    GDC – Austin '09 (1)
    HTML5 (8)
    IIS (11)
    iPhone (7)
    javascript (14)
    jQuery (6)
    Linq (2)
    mac os x (3)
    mySQL (4)
    Networking (1)
    Objective C (4)
    OO Design (3)
    php (7)
    Processing (1)
    Regex (2)
    REST (1)
    Sharepoint (1)
    SQL Server (15)
    Umbraco (3)
    Uncategorized (4)
    URL Rewriting (1)
    vb (1)
    VB.net (8)
    Video (1)
    WCF (4)
    Web Services (6)
    Windows (2)
    xhtml (4)
    XML (5)
    XPath (3)
    XSLT (1)

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

  •  

    July 2010
    M T W T F S S
    « Jun    
     1234
    567891011
    12131415161718
    19202122232425
    262728293031  
  • Archives

    • 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

    • Andrew Heasman
    • Dave Child
    • 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
    • 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
  • Recently Popular

    • The provided URI scheme 'http' is invalid; expected 'https
    • Asp.net nested ListView control's, with edit functionality- example
    • MIX2010 Videos
    • ListView using a DropDownList populated using code behind
    • Credit/ Debt card validation rules
    • ASP.net update panel's and jQuery
    • Collation issues setting up ASP.Net membership tables
    • The Path '/AppName/App_GlobalResources' maps to a directory outside this application, which is not supported.
    • How To Display Hierarchical Data Using Nested Repeater Controls and Visual C# .NET
    • Globalization "Current Culture" settings in the web.config (ASP.NET)
  • RSS Flexicoder Blog

    • CFBundleiconfile does not have an extension July 28, 2010
      Currently there is an issue with Apples Application Loader, although the documentation states that you can omit the file extension from the Icon File name, and this works when running locally, when you come to submit it to the app store it fails validation. At the moment you have to specify the names using the CFBundleIconFiles Social [...] […]
    • Truly quit app under iOS4 July 3, 2010
      Great article that explains how to terminate your app so that it doesn’t go into suspend mode, basic details are here Multi-tasking can be great, but it has added some complexity to programming on the iPhone. For many apps there really is no advantage. For instance, does the “That’s What She Said” button really need [...] […]
    • iOS4 EXEC_BAD_ACCESS with setHidesBottomBarWhenPushed June 24, 2010
      Raised the following bug with Apple, (Id 8126566) Get EXEC_BAD_ACCESS when hiding a bottom bar that doesn’t exist Steps to Reproduce: SettingsViewController* settings = [[SettingsViewController alloc] init]; [settings setHidesBottomBarWhenPushed:YES]; [self.navigationController pushViewController:settings animated:YES]; [settings release]; The active […]
    • SQL Server 2008 – Table Valued Parameters June 16, 2010
      Here is a great article that explains how to use TVP’s via .Net and a stored procedure Social Bookmarking […]
    • Getting Images onto the iPhone Simulator June 4, 2010
      To add your own pictures to the simulator, get the simulator running and then drag your image onto the simulator. This will cause the simulator to open it mobile safari. Then mouse down and hold on the image, you will then see the following prompt… Clicking save will then include your image. Social Bookmarking […]
    • Payments from Apple – Company VAT Return June 3, 2010
      Working out what you do with a payment from Apple, when you are lucky enough to get one, can be quite tricky for a VAT registered company, this is the information I’ve been able to gather so far, via the Apple Developers Forum (so thanks goes to them)….. Apple act as an undisclosed agent. You supply [...] […]

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

SetTextSize SetPageWidth