Post reply

restore all database into server from backup

  • August 24, 2006 at 12:21 am

    #62259

    hi

    how can i restore all the database some of then as 5 to 10 file group

    thanxs

    prabhu-bangalore 

  • August 28, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 28, 2006 at 8:29 am

    #657099

    Do you mean restore multiple databases from backup or restore a single database that has multiple filegroups? Or restore a single database and break it up into multiple file groups?

    Multiple databases get restored one at a time.

    If a backup has a database with multiple files, they will be listed in the header of the backup. Do a restore headeronly and look at the file names. Look at the WITH MOVE to get the individual files restored.

    If it's not broken up, you need to restore it and then create new file groups and move the clustered indexes to move the data.

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

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