Forum Replies Created

Viewing 3 posts - 46 through 48 (of 48 total)

  • RE: Transaction log not clearing out

    If you need/want to keep your database online:

    "dump tran <db> with truncate_only" followed by a shrink is very quick too

    (do make a full db backup before you start making...

  • RE: Instances: Yes or No?

    Just make sure you consider memory usage when you move to 1 or fewer instances. Each instance can now use up to 2 (3 if you use the /3GB switch...

  • RE: Transaction log file too large

    Another reason for the transaction log to fill up quickly could be an 'Optimization' maintenance plan ('reorganize data and index pages'). This may cause a transaction log about the size...

Viewing 3 posts - 46 through 48 (of 48 total)