Post reply

New DB Creation

  • November 20, 2008 at 8:48 am

    #127743

    When you create a new database sql server writes the data pages with 0's. In case of VLDB this process can take a long time to complete. I read some place that you can defer this write process and quickly create a large db and work on it but you run the risk of getting the data that was originally written to the disk. Is this true? If so what option does one use to accomplish this while creating a new database?

    TIA.

  • November 20, 2008 at 9:28 am

    #901126

    Its called Database File Initialization

    http://msdn.microsoft.com/en-us/library/ms175935.aspx

    MJ

  • November 20, 2008 at 9:40 am

    #901143

    Thank you

    Based on all the material out there, is this option enabled for all databases by default once the Perform Volume Maintenance Task privileges are assigned to the service account or is there some other option that needs to be set?

  • November 20, 2008 at 9:45 am

    #901150

    All data file creation/extension options will use instant initialization for data files created on NTFS volumes when SQL Server 2005 is running on Windows XP or Windows 2003 Server. Its an server wide option.

    http://www.sqlskills.com/blogs/kimberly/post/Instant-Initialization-What-Why-and-How.aspx

    MJ

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

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