File or Filegroup syntax

kermi

I've noticed in SQL Backup v 4 the help file indicates additional syntax. Specifically <file_or_filegroup> syntax after the database name. What is that specifically used for? Is this for backing up individual tables from a database? Can I get a better example of how it is to be used?

BACKUP DATABASE { database_name }
< file_or_filegroup > [ ,...n ]
TO { DISK } = { 'physical_backup_device_name' | '<AUTO>' } [, ..n]

Thanks

JKW :?:

petey

This is identical to the file/filegroup options in T-SQL, that allows you to backup selected data files or filegroups. Refer to Books Online for details, under the topic BACKUP (described), and the example in Backing up specific files or filegroups.