Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

script in sql server 2008 for generating .ndf files Expand / Collapse
Author
Message
Posted Monday, June 17, 2013 5:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 20, 2013 10:38 PM
Points: 8, Visits: 23
can any one give me script for generating .ndf files in sql server 2008
Post #1464090
Posted Monday, June 17, 2013 5:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 12,923, Visits: 32,318
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:

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/76e132fe-aabb-476f-9e3e-4b634daf6269/

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1464094
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse