How do I schedule Automatic Database Backups?

This article will walk you through how to schedule your SQL server to automatically generate backup copies of your databases on a nightly basis.

Follow the instructions below to schedule your SQL Server to automatically generate backup files for each of your databases on a nightly basis.

Create a support ticket requesting a Server Intellect Technician to download and install the Backup software to your server.

Go into the C:\backup\ folder.

The next step changes depending on what version of SQL Server you have installed.

SQL Express: Go into the "SQL Express" folder and Open the "createbackuppro.SQL" file with Management Studio Express.
SQL Workgroup or Standard Edition: Go into the "Full SQL Server" folder and Open the "SQL Server Full Backup.sql" file with Management Studio.

Once Management Studio opens the SQL Query file, Click the "Execute" button to run the query. This query will create a stored procedure to handle the database backup job.

You should see a "Command(s) completed successfully." message after clicking the Execute button. If an error occurs, contact support for assistance.

If you have either Workgroup or Standard Edition, you are done. The backup script will automatically generate backup files for your databases to the C:\BACKUP\Database folder nightly at 12:30 AM Server Time.

If you have SQL Express, simply double-click the "schedulebackup.bat" file to schedule the backup job to run on a nightly basis at 12:30 AM Server Time.

Always follow up the next day to ensure the backup script is executing successfully.