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 1:56 pm

    #941638

    ichbinraj (2/10/2009)

    Hi ,

    I have 2TB database in production which has 1 MDF file ,2NDF files i am Planning to add one more datafile with out any down time in production ? Can I add file directly to DB right click and add file ?

    appreciate your comments and suggestion.

    Thanks

    Ichbin

    Is your existing ndf file taking all the space on the disk, if so are you creating a new ndf file on a new drive with enough space. Only in this case you need to add a new ndf file.

    However, you can right click database, go to properties and then go to Files tab in the Select a page section.

    On the bottom click on add and name the file and specify the location. I assume this is a SQL 2005 database

    Also, as Gail suggested you can use the ALTER DATABASE command too.

    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."