cancel
Showing results for 
Search instead for 
Did you mean: 

Changing the installation path for the SQL databases

Eric_Reid
Level 2
Is it possible to re-direct the installation of the SQL databases created during the Backup Exec installation? I'm installing BE using an existing SQL 2000 Server and would like BE to install it's Database files under D:\Program Files\Microsoft SQL Server\MSSQL\Data instead of C:\Program Files\Veritas.

Thanks
4 REPLIES 4

John_Chisari
Level 6
Partner Accredited
It can be done, but not during the installation.

I tested this with the default MSDE instance, but it should be the same with SQL.
1. Install BE as normal.
2. Stop all the BE services and the MSSQL service to the instance which the BE Database was installed to.
3. Change HKEY_LOCAL_MACHINE\SOFTWARE\VERITAS\Backup Exec\Engine\Misc\Data Path to whatever you want it to be.
4. Move the contents of the original Data Path ie. \Backup Exec\NT\Data to the new directory.
5. Start all BE services.

Pleas note however, it won't just be the BE database files and log file, it will also be all the Job Logs as well which will be put under this directory.


The steps mentioned by John worked perfectly for the MSDE instance of Backup Exec. However, It is recommended, prior to making changes in the registry, to run a complete back up of the registry and server.



Warning: Incorrect use of the Windows Registry Editor may prevent the operating system from functioning properly. Caution must be exercised while making changes to the Windows Registry.Message was edited by:
Sagar Kamat

Sagar_Kamat_2
Level 6
The steps mentioned by John worked perfectly for the MSDE instance of Backup Exec. However, It is recommended, prior to making changes in the registry, to run a complete back up of the registry and server.



Warning: Incorrect use of the Windows Registry Editor may prevent the operating system from functioning properly. Caution must be exercised while making changes to the Windows Registry.

Eric_Reid
Level 2
Thanks you,

Warren_Rowe
Level 3
Can anyone explain how the SQL instance knows where to find the database after the move?

Warren