Results 1 to 4 of 4

Thread: transaction log size

  1. 07-17-2003, 01:28 AM #1
    bhavna
    bhavna is offline Registered User
    Join Date
    Jul 2003
    Posts
    23

    transaction log size

    This isin continuation with my previous query. If i cannot reduce th T Log size , how can i stop it from increasing further. Can i make secondary log files which can be deleted later on?
    Reply With Quote Reply With Quote
  2. 07-17-2003, 04:10 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. you can reduce Tlog log size. checkpoint, dbcc shrinkfile
    2. you can put a limit on tranlog growth
    3. yes you can delete a secondary log - after emptying it. (dbcc srinkfile emptyfile)
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-17-2003, 08:21 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If you want to you can change the database recovery model to Simple and SQL Server will take care of trucating the log.

    You can also set the option Auto Shrink to ON.

    But doing these is not recommended on a production database.
    Reply With Quote Reply With Quote
  4. 07-17-2003, 10:18 AM #4
    KnooKie
    KnooKie is offline Registered User
    Join Date
    Jan 2003
    Location
    UK
    Posts
    277
    http://www.databasejournal.com/scrip...le.php/2208761
    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