Results 1 to 3 of 3

Thread: How to reduce the size of the transaction Log

  1. 07-10-2001, 02:57 PM #1
    Jesús Macías Guest

    How to reduce the size of the transaction Log

    I have defined the Transaction log for MyDatabase to Unlimited grow; and it has been growing; does anyone knows how could I reduce the file space used for this ?
    Reply With Quote Reply With Quote
  2. 07-10-2001, 06:29 PM #2
    Bill Guest

    How to reduce the size of the transaction Log (reply)

    use DBCC SHRINKFILE. If it doesn't seem to be shrinking, check sqlserverfaq.com and search "shrink tran log" for Neil Pike's (i think) article.


    ------------
    Jesús MacÃ*as at 7/10/01 3:57:06 PM

    I have defined the Transaction log for MyDatabase to Unlimited grow; and it has been growing; does anyone knows how could I reduce the file space used for this ?
    Reply With Quote Reply With Quote
  3. 07-10-2001, 08:56 PM #3
    sethu sr Guest

    How to reduce the size of the transaction Log (reply)

    Hi

    my home pase www.jsethu.da.ru has info on log shrink
    i hope it will be usefull to you.

    Sethu


    ------------
    Bill at 7/10/01 7:29:20 PM

    use DBCC SHRINKFILE. If it doesn't seem to be shrinking, check sqlserverfaq.com and search "shrink tran log" for Neil Pike's (i think) article.


    ------------
    Jesús MacÃ*as at 7/10/01 3:57:06 PM

    I have defined the Transaction log for MyDatabase to Unlimited grow; and it has been growing; does anyone knows how could I reduce the file space used for this ?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules