How to initial space for a log file?

  • Actually, it is a question in Sybase. For some reasons, we cannot set autogrowth for data/log files. The size of a log file, therefore, is fixed, or can be only changed manually. To better plan a size for logs, we need to know how much data we will import and how we import the data. Is there any way in estimating the size of the log file? Say, if we have 1 GB plain text file, what is the size of the log file should be?

    Any input will be greatly appreciated.

  • I don't think there is anyway to estimante the log file size but you can check the log file size every few minutes and inrease it if there is no more free space...

    dbcc sqlperf(logspace)

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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