Modifying the maintenance plan backup location

Maintenance plans automate database tasks necessary to ensure database integrity and recovery in case of data loss.

Grass Valley recommends that the database backup location be network storage, preferably one that is backed up or has some kind of RAID protection. If the database is backed up to a network share, the account under which SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER) run must have permission to write to the network share. If these services are running a virtual Network Service or NT Service\MSSQLSERVER account, then the network share must have permission for the computer account (e.g., yourDomain\StratusCoreServer$).

To create or manage maintenance plans, you must log in as a member of the sysadmin fixed server role.

Open and log in to Microsoft SQL Server Management Studio.
In the tree-view, open the Management | Maintenance Plans nodes.
Right-click the plan, and click Modify. A Plan Design panel opens.
Double-click Backup Database Task. The Backup Database Task dialog box opens.
In the Backup Database Task dialog box, in the Folder field, modify the backup directory path.
Click OK on the Backup Database Task dialog box.
Close Server Management Studio and answer Yes when prompted to save changes.