If you write Access applications professionally, there's a good chance you frequently work with SQL Server. And if you work with SQL Server, you should know about Ola Hallengren.
Ola maintains a set of backup and maintenance scripts for SQL Server that are simply awesome. Better yet, you can get these scripts for just three easy installments of $0. Yep, Ola gives them away.
Anyway, I'm not going to go into great detail about how to use them. Just head on over to Ola's site and have a look. You won't be disappointed.
Ola.Hallengren.com: SQL Server Backup, Integrity Check, and Index and Statistics Maintenance