How are my MS SQL databases being backed up for my Windows VPS?

The following article explains how your MS SQL databases are backed up for your Windows VPS. By default, a task is configured to backup all MS SQL Workgroup databases that you create. Automated backups are not performed for MS SQL Express databases. The backups are performed at the same time each day and stored on your server. These backup files can be used to perform a restore of your database if you lose any data or if the database becomes corrupted.

Note: We strongly recommend that you do not remove the backup task or the individual backup files. The backups are performed to help protect your data. If you need to alter or remove the backup task, please contact our support department.

MS SQL Express

We recommend configuring backups for MS SQL Express on an as needed basis for VPS plans that include MS SQL Express.

MS SQL Workgroup

Windows VPS plans that include MS SQL Workgroup have database backups performed each day by a job scheduled in MS SQL Management Studio. The backup file, which will have a .bak extension, will be stored on your Windows VPS in the following location: D:\SQLBackups\. Within this directory, there will be a separate folder for each backed up database. Each backup file will remain on the server for 5 days, at which time they will be replaced by the new backup performed.