How to back up files and filegroups (Transact-SQL)

To back up files and filegroups

• Execute the BACKUP DATABASE statement to create the file and filegroup backup, specifying:
  • The name of the database to back up.
  • The backup device where the database backup will be written.
  • The FILE clause for each file to back up.
  • The FILEGROUP clause for each filegroup to back up.

Note Backing up files or filegroups requires careful planning; otherwise, the database may not be recoverable.

Examples

This example performs a backup operation with files and filegroups for the MyNwind database.

-- Back up the MyNwind file(s) and filegroup(s)

BACKUP DATABASE MyNwind

    FILE = 'MyNwind_data_1',

    FILEGROUP = 'new_customers',

    FILE = 'MyNwind_data_2',

    FILEGROUP = 'first_qtr_sales'

    TO MyNwind_1

GO

See Also