mca.deepak3335 (6/17/2013)
can any one give me script for generating .ndf files in sql server 2008
did you mean scripting existing files?
fastest way i think would be to right click on the database of your choicein object explorer, Script Database As >>Create;
that would automatically generate the TSQL, which would include all file names, including additional files like ndf files.
did you mean adding new ones to an existing database?
here's a link and example:
ALTER DATABASE test
ADD FILEGROUP ww_Group
GO
ALTER DATABASE test
ADD FILE
( NAME = ww,
FILENAME = 'D:\wwdat1.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB)
TO FILEGROUP ww_Group
Lowell