Create a backup in SSMS and Script Action to job option. In the new ... SQL Alternatively, you can use the T-SQL commands to create files or filegroups backup. BACKUP DATABASE [Northwind] FILEGROUP = ...

SQL Server lets you use one command to ... To do this, you can create a new table containing only the records of Fort Myers employees in the central Employee Records database.