Backup frequency recommendation
 
accesso suggests that you perform full backups nightly, for example, at 2:00 AM, and then differential backups every hour starting at 9:00 AM until an hour after salespoints are closed – usually 5:00 PM for a day venue. The following sections describe how to perform these backups using facilities available with SQL Server.