Windows LiveWindows Live™
 
 
Deepankar's profile.NET Rocks!!!PhotosBlogListsMore Tools Help

Blog

    The log file for database is full. Back up the transaction log for the database to free up some log space.

    When dealing with MS SQL (not MY SQL) I’ve seen this error message before, but found little help on it out there.
     
    The log file for database db_name is full. Back up the transaction log for the database to free up some log space.
     
    Within the MS SQL Query Analyzer, do this:
    backup log db_name with truncate_only
    go
    dbcc shrinkfile (db_name_log,0)
    go
     
    If anything, this post will be useful for me in the future when one of my MS SQL databases coughs up the error again
    January, 2007 10:13 PM | Add a comment | Permalink | Blog it | Databases

    Talking about Blogging: Design Your Own Weblog Application from Scratch Using ASP.NET, JavaScript, and OLE DB

     

    Quote

    Blogging: Design Your Own Weblog Application from Scratch Using ASP.NET, JavaScript, and OLE DB
    The ASP.NET advanced templated controls, such as the DataList and DataGrid, are perfect for many data representation situations. However, when you need the flexibility to render a variety of layouts, the Repeater control is what you need. In this article the author builds a full-featured blog application to illustrate the use of the Repeater and DataList controls that render nested data in a master-detail relationship. He then discusses how to override the default implementations of these controls by adding some client-side JavaScript code that makes the blog more responsive and enhances its usability.
    January, 2007 5:07 PM | Add a comment | Permalink | Blog it | ASP.NET