Upgrade to 5.4 or 5.5 failed because the DataBase was corrupt (4044496)

Upgrade to 5.4 or 5.5 failed because the DataBase was corrupt.

Coruption in the DataBase

1. To test if the DB is corrupt
2. Download SQL Express Management Studio
3. Try to connect to the vRanger DataBase
4. If you can connect there might be another issue
5. If you can’t connect the DataBase is probably corrupt
6. Download the Full install package for vRanger 5.4 or 5.5
7. Uninstall vRanger
8. Say “yes” to Full uninstall (DB is bad anyway)
9. Delete the Quest Software folder
10. Run the cleanup script
11. Copy the below script *
12. Save the below script as a .bat file
13. Answer “y” or “yes” to all questions
14. Reboot the VM
15. Install the Full package you downloaded earlier
16. If it fails with the Database already exists at location c: ...
17. Go to the location in the error and delete the vRanger .mdf and.ldf files
18. Run the Full install package again

*

sc stop "Quest Catalog Service"

sc stop "vRanger Service"

sc stop "vRanger FLR Service"

sc stop "vRanger API Service"

sc stop "vRanger Pro Service"

taskkill /IM vRanger.API.exe /F

taskkill /IM Vizioncore.vRanger.Service.exe* /F

taskkill /IM UsdiService.exe* /F

reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\vRanger Backup & Replication"

reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Vizioncore, Inc."

reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\vRanger Pro"

reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\App Paths\vRanger Backup & Replication"

reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\CatalogManager"

reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall\vRanger Backup & Replication"

reg delete "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\vRanger API Service"

reg delete "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\vRanger FLR Service"

reg delete "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\vRanger Service"

reg delete "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Quest Catalog Service"

sc delete "Quest Catalog Service"

sc delete "vRanger Service"

sc delete "vRanger FLR Service"

sc delete "vRanger API Service"

sc delete "vRanger Pro Service"