Partial backups are new in SQL Server 2005.
Description from Microsoft Books Online:
A partial backup is similar to a full backup, but a partial backup does not contain all of the file groups. Partial backups contain the all the data in the primary file group, every read-write file group, and any specified read-only files. A partial backup of a read-only database contains only the primary file group.
The native SQL Server syntax to run a partial backup is as follows:
BACKUP DATABASE pubs READ_WRITE_FILEGROUPS TO DISK = 'c:pubs.bak'
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of LiteSpeed for SQL Server
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center