Database backup

[LaughingBull]

Is there a way to have the database automatically backup every day at a certain time?

[JoeM]

Just use Windows Scheduler to run a job at a certain time of the day to copy the database to your backup location.
I often add a datestamp to the file name to differentiate the backups (usually hav my Scheduler run a batch file or vb script to copy/rename the database).
Just make sure that whatever computer you run this from is on at that time of the day (we usually do it from a server).