How can we help you today? How can we help you today?

File or Filegroup syntax

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 :?:
kermi
0

Comments

1 comment

Sort by
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.