How to change the Backup Exec database location to a new instance using BEUtility

How to change the Backup Exec database location to a new instance using BEUtility

Article: 100001771
Last Published: 2019-11-29
Ratings: 1 5
Product(s): Backup Exec

Problem

How to change the Backup Exec database location to a new instance using BEUtility.

Note: Ensure the SQL server version to which  the database is moved to is same or higher than the existing SQL server version.

Solution

1. Launch BEUtility from the Backup Exec directory
  • Path - C:\Program Files\Symantec\Backup Exec\beutility.exe (For Backup Exec versions till BE 15 and environment upgraded to BE 16 or BE 20)
  • Path - C:\Program Files\Veritas\Backup Exec\beutility.exe   (For fresh BE 16 or BE 20 install)
2. Click All Media Servers > right-click the media server name > select New Backup Exec Database Location.
 

  User-added image

3. Click " Yes" on The Remote Registry Service pop-up message if displayed.


Image

4. Select or manually enter servername\instancename in the Destination SQL Server instance and click OK
 
  Image

5. Allow the process to complete and click close.

Image


Image


Image
 
6. Enable Common language runtime (CLR) functionality
  1. Stop Backup Exec services
  2. Open command prompt
  3. Start sqlcmd

sqlcmd -E -S <new server name>\<new instance name>

  1. Execute the following SQL command

1> sp_configure 'clr enabled', 1
2> go
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
1> reconfigure
2> go
1> USE bedb
2> go
Changed database context to 'BEDB'.
1> EXEC sp_changedbowner 'sa'
2> go
1> ALTER DATABASE bedb SET TRUSTWORTHY ON
2> go
1> exit

  1. Start Backup Exec services
 

Was this content helpful?