How can you use READ_WRITE_FILEGROUPS option with SQL LiteSpeed, what is the syntax that you need to use ?
This is something that was introduced in version 4.8. It should work in the following way;
To be able to do a partial backup and restore, then the user should use @read_write_filegroups=1 on the backup and @with='PARTIAL' on the restore. This will backup the primary filegroup and any read/write file groups and then restore the primary and any read/write filegroups.
For additional info, also see SOL37827, SOL20114, SOL32757 for detail onREAD_WRITE_FILEGROUPS
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center