How to move the vRanger Pro DPP database.
The vRanger database can be moved to a different location but only on the same system, it cannot be moved to a different machine.
This can be done either with a GUI or via the command line. The first thing to do is to close the vRanger GUI and stop all three of the vRangerPro services. To do this using a GUI you can download MS SQL Server Management Studio Express. This is a free tool that is available from the Microsoft site.
1. Right click on the vRangerPro database and select Tasks, then Detach, accept the defaults and hit OK. 2. Copy the vrangerpro.mdf and vrangerpro_log.ldf (they should be in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data) to the new location.
3. Right click on Databases, select Attach, then Add and browse to the new mdf file location.
Via the command line:
1. Type sqlcmd -s \vrangerpro. you will see the 1> prompt.
2. Type sp_detach_db 'vRangerPro' and hit enter. Type go and hit enter. Move/copy mdf and ldf file to a new location.
3. Type sp_attach_db 'vRangerPro', '\vrangerpro.mdf', '\vrangerpro_log.ldf' and hit enter. Type go and hit enter.
4. To verify that everything is OK type select name from sys.databases and hit enter, this should return a db list including vRangerPro.
5. Type exit.
6. Start the vRanger services and open the vRanger GUI.
