How To Backup Your Database - Microsoft SQL

SQL Server Management Studio

1. Launch the SQL Server Management Studio Express utility on your database server and authenticate yourself by providing the required details to establish connection to your database server.
2. Upon successfully authenticating, expand the Databases folder within your object explorer panel to display the list of hosted database.
3. Right click the desired database and select Tasks > Back Up > General to configure the available backup parameters for your database.
4. Lastly select the Options page to append additional options to your database backup job.

SQL Server Management Studio - SQL Server Agent

1. Launch the SQL Server Management Studio utility on your database server and authenticate yourself by providing the required details to establish connection to your database server.
2. Upon successfully authenticating yourself, expand the SQL Server Agent service within your object explorer panel to display the Jobs folder.
3. Right click the Jobs folder and select New Job to display the New Job window. Select the General page to configure the backup parameters for your database.
4. Then while still displaying the New Job window, select the Schedule page to configure a scheduled routine for the backup job.
5. Upon finalizing the backup parameters, click OK to save and apply your scheduled backup routine. A title summary of your backup job will be presented under the SQL Server Agent > Jobs folder list.

SQL Server Management Studio - Maintenance Plan

1. Launch the SQL Server Management Studio utility on your database server and authenticate yourself by providing the required details to establish connection to your database server.
2. Upon successfully authenticating yourself, expand the Management folder within your object explorer panel to display the Maintenance Plan folder.
3. Right click the Maintenance Plan folder and select New Maintenance Plan to create a backup plan. Double click the Back Up Database Task from the toolbox and configure the backup parameters respectively.
4. Then while still displaying the Maintenance Plan window, click the Schedule button to configure a scheduled routine for the backup plan.
5. Upon finalizing the backup parameters, click OK to save and apply your scheduled backup routine. A title summary of your backup plan will be presented under the Management > Maintenance Plan folder.