For optimal results, the Backup Exec Database (BEDB) SQL instance should not share a SQL instance with other applications

Article:TECH35935  |  Created: 2004-01-05  |  Updated: 2011-04-04  |  Article URL http://www.symantec.com/docs/TECH35935
Article Type
Technical Solution

Product(s)

Environment

Issue



For optimal results, the Backup Exec Database (BEDB) SQL instance should not share a SQL instance with other applications


Solution



Symantec recommends against installing the Backup Exec (BEDB)  database into a SQL Server instance that also contains data pertaining to another application for two reasons:

1. Database maintenance and shutdowns of the Backup Exec SQL database may inadvertently affect production databases.

2. Restores of the master database in a production SQL instance would be impossible with Backup Exec using that instance. The automated recovery method would not be able to put the instance into single-user mode. Switching to the manual method would also be hampered, as once the service was started in single-user mode, Backup Exec would be that single user using the Backup Exec database which would prevent a restore of the master database.

Therefore, it is recommended to allow the Backup Exec is installed in a separate SQL or SQL Express instance for the Backup Exec database and that additionally no applications are installed to the same instance at a later date.


Legacy ID



273485


Article URL http://www.symantec.com/docs/TECH35935


Terms of use for this information are found in Legal Notices