Spliting Data File into multiple

  • Hello.

    I have a database with single data file and i want to split that data across

    multiple data files.

    Coulf u pls help me how to achieve this

    Thanks,

     

  • Probably this will work for you. First, for existing mdf file uncheck check box "Automatically grow file' (i.e. to prohibit it's growing). Then create, let say, 2 extra ndf files. Load into your DB (using DTS for example) copy of your tables (with new names that later you will rename). That's it- new ndf files will be filled with your old data (actually, after that you need to drop initial tables and rename new table copies to old ones). 

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

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