Post reply

Restoring from one data file to multiple data files

  • September 8, 2008 at 1:34 pm

    #193319

    Hi,

    I need to move about 70 databases to a new server. On the old server, there is one mdf and one ldf for each database. On the new server there will be one mdf, one ndf, and one ldf for each database. The 2 new data files will be on PRIMARY and on a separate set of drives. Is there a way to use a “Restore Database” script to get the data into the 2 new datafiles?

    Or is there a better way other than Importing/Exporting the records?

    Thank you.

  • September 8, 2008 at 3:28 pm

    #868760

    you;ll need to move the data files over first and attach them to the server. Then you create the extra filegroups. Then create\move objects into those filegroups

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • September 8, 2008 at 7:06 pm

    #868810

    Thanks, Perry.

    There will be only one filegroup – PRIMARY. What I am shooting for is to get the data to evenly span across multiple volumes and drives. But I was hoping to script this through a restore or some other method and just let it run overnight as opposed to selecting the objects to move or creating packages.

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

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