Restore across multiple files/disks

PDRegan

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

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.

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?

petey

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

PDRegan

cheers matey