How to Create a File or Filegroup Backup Using T-SQL Alternatively, you can use the T-SQL commands to create files or filegroups backup. BACKUP DATABASE [Northwind] FILEGROUP = N'PRIMARY' TO DISK = ...