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