Home Forums SQL Server 2005 Administering How to Add Datafile.ndf in Production database ? RE: How to Add Datafile.ndf in Production database ?

  • February 10, 2009 at 2:16 pm

    #941656

    ichbinraj (2/10/2009)

    if I add file according to your specification do I need to restart the MS SQL server ?

    As a DBA always learn to say No and please Question as many things as you can.

    However, for a large database having more than a couple data files is recommended.

    ADDING A FILE DOES NOT NEED REBOOT, you can add as many files as you want but don't have too many files too.

    Also place the new ndf file on a better RAID like RAID 10 or RAID 1..

    Thanks!!

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."