Options
Restore across multiple files/disks
PDRegan
Posts: 12
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
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
There are only 10 types of people, those who get binary jokes and those who dont.
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
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?
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8