Results 1 to 5 of 5

Thread: Truncate Log

  1. #1
    Join Date
    Feb 2003
    Posts
    19

    Unanswered: Truncate Log

    Does anyone know how to truncate log without grow up space used?

    Thanks
    Sbahri

  2. #2
    Join Date
    Aug 2005
    Location
    Sharjah, UAE
    Posts
    25
    Quote Originally Posted by sbahri
    Does anyone know how to truncate log without grow up space used?

    Thanks
    Sbahri
    BACKUP LOG database_name WITH TRUNCATE_ONLY
    Pinoy ako, pinoy tayo! Ipagmalaki mo...

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Use SIMPLE recovery model and set an optimum value to Transacation log file, otherwise the bulk load and database maintenace jobs will increase the size of Tlog.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Feb 2003
    Posts
    19
    Quote Originally Posted by trojanz
    BACKUP LOG database_name WITH TRUNCATE_ONLY
    thanks for your help.

    btw,I have 5GB current size on log and space used is 26MB.
    How to change 5GB current size into 500MB...?

    Thanks
    sbahri@rocketmail.com

  5. #5
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    Dbcc Shrinkfile ...?
    Cheers....

    baburajv

Posting Permissions

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