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 = ...

allowing you to make safe backup copies or send data to branch offices. Once you disconnect a database, you must restore it from its .MDF file in a process called "attachment." SQL Server offers ...