Manage MSSQL backups with Scheduled Tasks

Last Updated on Monday, 22 November 2010 03:03 Written by Andrea B. Sunday, 21 November 2010 10:33

Arvixe customers have 2 options to manage MSSQL databases backups.

The first option is to manually backup databases using  Microsoft SQL Server 2008 Management Studio.

A detailed explanation of how to backup using MSSQL 2008 Management Studio can be found here.

The second and most useful option, in my opinion, is to schedule database backups using the ‘Scheduled Tasks‘ feature you can find in the Arvixe Control Panel.

How to backup a MSSQL database using Microsoft SQL Server 2008 Management Studio Express

Last Updated on Wednesday, 11 April 2012 01:57 Written by Shai Ben-Naphtali Tuesday, 24 November 2009 09:37

Related documents:
1. How to Use Microsoft SQL Server 2008 to Connect to your Database
2. How to Fix the “The server principal ( ) is not able to access the database ( )” Error In Microsoft SQL Server Management Studio
3. How to restore an MSSQL .bak database using Microsoft SQL Server 2008 Management Studio Express

Arvixe customers can enjoy the ability of remote management of their MSSQL databases using the free software from Microsoft called Microsoft SQL Server 2008 Management Studio Express.

This blog post will explain how an Arvixe customer can backup a database to the hosting space and later download it to keep offline to restore when needed.
Note: Per Arvixe’s TOS and AUP, keeping a backup on your hosting space is not allowed. Please make sure that after you create a backup, you download it to your local PC/Server and remove it from the hosting space.