What are the challenges you face when working across database platforms? Take the survey
Options

File or Filegroup syntax

kermikermi Posts: 47
edited January 25, 2006 12:02PM in SQL Backup Previous Versions
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 :?:

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.