Every small company has a database that quietly runs the business: the customer list, the invoices, the orders, the stock. Nobody thinks about it until the morning it will not open. A backup schedule is not an IT ritual. It is the difference between losing an afternoon and losing three years of records.
The rule is simple to remember and easy to apply. Keep three copies of the data, on two different types of storage, with one copy offsite. In practice: the live database, a backup on a separate disk or server, and a copy in cloud storage or at another location.
The part companies skip is the third one. Two backups sitting in the same room as the server protect you from a deleted table, not from a fire, a theft, or ransomware that encrypts every drive it can reach.
Daily files are for accidents. Weekly and monthly files are for mistakes nobody noticed at the time, which are the harder ones.
This is where most schedules fail quietly. A job shows "completed" every night for a year, and the first restore attempt reveals the file was empty or the password was lost. Restore one backup into a test environment every month or two, and confirm the tables open and the row counts look reasonable.
Write down how long the restore took. That number, not the backup size, tells you how long the business would be down.
Never keep the only backup on the same server as the database. Encrypt the files, control who holds the key, and limit access to the people who actually need it. Store the key somewhere separate from the backup, or an encrypted file you cannot open is just a heavy file.
Then name one person responsible for checking that the job ran, and a second person who knows where the files and the key are. Document the schedule, the storage locations, the retention period, and the restore steps in one page that lives outside the server. Q8DM sets up these routines for small companies and reviews them when systems change.
If you cannot answer where last night's backup is right now, that is the task for this week. Start with one automated daily dump and one copy offsite, then build from there. Reach us at q8dm.com.