Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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 @ 1:51 AM
Points: 13,971, Visits: 36,265
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Post #1464094
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse