Post reply

How to determine disk space required for the transaction log backup ?

  • March 30, 2006 at 5:31 am

    #111600

    On Full recovery model of a database, how to find out the disk space required for the transaction log backup ?

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • March 30, 2006 at 5:59 am

    #629794

    How many transactions are you expecting?

  • March 30, 2006 at 8:15 am

    #629874

    Is that no.of tranactions?

    Would be around 1000 transaction per hour.

     

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • March 31, 2006 at 9:16 am

    #630170

    It will depend on what sort of data is being modified, I would imagine-- lots of text or a few tinyints.

    It will also depend on how often you run transaction log backups.

    Note that rebuilding or reorganizing indexes in FULL recovery mode will cause the transaction log to balloon to the size of your database or larger.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply