Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

How do I Schedule Automatic Database Backups?

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.

kb-sql-automatic-db-backups

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.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.