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

Image by Pete Linforth from Pixabay