You can schedule the job to run daily, hourly, etc ... 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 ...