Post reply

Transaction log

  • April 6, 2006 at 12:06 pm

    #116867

    Hi,

    What will be the impact if someone tries to delete the transaction log - instead of shrinking the huge log .......?

    Thnx,

    Natalie.

     

     

  • April 6, 2006 at 12:26 pm

    #631329

    You cannot delete the log. It is an open file that is essential for the database to function.

    A database cannot run without a log file.

  • April 11, 2006 at 12:24 pm

    #631950

    There's an excellent section on BOL for simple transaction log recovery models...you should read it and see if it's suitable for the kind of database that you're working with..







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply