script in sql server 2008 for generating .ndf files

  • can any one give me script for generating .ndf files in sql server 2008

  • 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!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply