In SQL Server, the database can be stored in different files ... STATS = 10 You can schedule to run a backup at a certain time. To do that, create a backup in SSMS and select the Script > Script ...