Restore across multiple files/disks

Comments

• petey Redgate › Posts: 2,358 New member

  May 2, 2007 4:57AM

  No, it is not possible to restore a database to a different file/filegroup structure. You can just restore it to a different location using the MOVE option.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• PDRegan Posts: 12

  May 2, 2007 7:13AM

  Ok, cheers pete,
  any pointers on how i split the original large file into smaller files? I can create extra data files for the db to use but how is the data moved to these new smaller files?

  There are only 10 types of people, those who get binary jokes and those who dont.

  0 · Share on Twitter
• petey Redgate › Posts: 2,358 New member

  May 2, 2007 7:27AM

  Googling ought to turn up some interesting stuff, e.g. http://sqljunkies.com/HowTo/B9F7F302-964A-4825-9246-6143A8681900.scuk).

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• PDRegan Posts: 12

  May 2, 2007 7:31AM

  cheers matey

  There are only 10 types of people, those who get binary jokes and those who dont.

  0 · Share on Twitter