Post reply

Database ABC has more than 1000 virtual log files which is excessive issue

  • October 10, 2012 at 6:04 am

    #282987

    I restored a SQL2000 db into SQL2008R2 and I am getting this message:

    Database ABC has more than 1000 virtual log files which is excessive. Too many virtual log files can cause long startup and backup times. Consider shrinking the log and using a different growth increment to reduce the number of virtual log files.

    I cannot seem to find any information on this. Can anyone help?

  • October 10, 2012 at 6:25 am

    #1547616

    Kimberly Tripp's blog at sqlskills.com

    http://www.sqlskills.com/blogs/kimberly/post/Transaction-Log-VLFs-too-many-or-too-few.aspx

  • October 10, 2012 at 7:31 am

    #1547651

    I ran the DBCC LOGINFO() and found a lot of growth fragmentation in the files. I had the mdf and ldf file growth too low and when I rebuilt the indexes it grew over 1,000 times apparently. So, after I restore it into SQL2008, I will shrink the trans log to minimal, then grow the trans file to what it should be and I have upped the growth on the mdf and ldf files to much larger growth chunk.

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

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