Results 1 to 2 of 2

Thread: Log is full??

  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: Trigger

    What would be the best way to have the database run the following command when the logfile reaches a certain size?

    BACKUP LOG kingjohnor WITH TRUNCATE_ONLY
    GO

    USE kingjohnor

    DBCC SHRINKFILE(kingjohnor_log,1)

    Thanks in advance for help : )
    Last edited by Indevgroup; 05-27-04 at 16:32.

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    If you are not going to back uo the transaction log file, then why not change your recovery mode to simple? This way the trans log will not grow at all - it will only hold uncommitted transactions.
    Regards
    Dbabren

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •