How can we help you today? How can we help you today?

Restore across multiple files/disks

Hi
Is it possible to restore a db across multiple data files, if the backup was created with only the primary, 1 large datafile (250G) and the log file, ie i need to restore datafile across different files on different disks in the same group? If so, can you point me at some syntax examples?

Thanks in advance
PDRegan
0

Comments

4 comments

Sort by
  • petey
    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.
    petey
    0
  • PDRegan
    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?
    PDRegan
    0
  • petey
    Googling ought to turn up some interesting stuff, e.g. http://sqljunkies.com/HowTo/B9F7F302-964A-4825-9246-6143A8681900.scuk).
    petey
    0
  • PDRegan
    cheers matey
    PDRegan
    0

Add comment

Please sign in to leave a comment.