How to back up a full version of SQL (not express) in TAC Vista

[Product_Support]

Issue

How to back up a full version of SQL (not express)?

Product Line

TAC Vista

Environment

• SQL 2005, 2008 full versions, i.e. Enterprise, Standard etc.
• TAC Vista 5.1.X

Cause

A customer may wish to backup the TAC Vista log database to prevent data loss if the SQL server crashes.

Resolution

There are 2 options available, depending on the TAC Vista SQL configuration the customer has configured.

1. If the customer has selected "Typical" on the TAC Vista Server setup "SQL" tab, you can configure this through Vista workstation.
   1. Right-click on the Server object in Workstation and select "Properties".
   2. Select the "Log Backup" tab and configure the backup schedule there.

      

2. If the customer has selected "Custom" on the TAC Vista Server Setup "SQL" tab, this can be configured through SQL Management Studio (which is free to download from Microsoft, if the customer doesn't already have it).

   1. Start SQL Management Studio and connect to the SQL server instance that is being used for TAC Vista.

   2. Expand the SQL server in the tree (in SQL Management Studio) and locate the "Management" folder.

   3. Expand that folder and locate the "Maintenance Plans" folder.

   4. Right-click on the folder and either select "Maintenance Plan Wizard" or "New Maintenance Plan".

   5. Configure as required.