Grass Valley Aurora Browse v.7.0 Installation - Manual (Page 144)

144 Aurora Browse Installation and Configuration Guide April 6, 2010
Chapter 6 Database and Recovery Planning
3. If the database is backed up to a network share, modify the account that the SQL
Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER) run as. It
needs to run using an account that has permission to write to the network shared
location for the database backup.
Using the simple maintenance plan
Once you have configured the maintenance plan, you can run the executable file and
it will automatically configure SQL Server to run maintenance tasks shown in the
following workflow at the scheduled time.
CAUTION: When you run the maintenance plan, it deletes any
previously created maintenance plans and all associated jobs and
schedules. To retain these files, save them under a different name
before running the maintenance plan.
To customize the maintenance plan, use SQL Server Management Studio (SSMS)
under
<server name> + Management + Maintenance Plans . If the SSMS is open while
the maintenance plan is running, the SSMS will not reflect the latest scheduling
information. Restart the SSMS to display the correct information.