• baabhu (12/7/2012)


    ...The only thing you've to consider is database file sizing is costly operation. Consider you apply on non peak hours. Restrict your file growth 8 GB or less.

    Yes, one of the things mentioned in the TechNet article I linked to talks about file initialization. To help speed up file initialization when growing a file that much at once, you should consider using instant initialization. Here's an article with a more in depth look at this:

    http://www.sqlskills.com/blogs/kimberly/post/instant-initialization-what-why-and-how.aspx