How to recreate the SQL localDB instance

Use these steps to recreate the Cayosoft Guardian SQL LocalDB instance when requested by Support.

1. Stop the Cayosoft Guardian service.
2. Wait 10–15 minutes. After the service is stopped, SQL LocalDB should detect that nothing is using it and shut down after some time.
   • (Optional) Check Task Manager for sqlservr.exe running under the System account.
   • Do not kill all sqlservr.exe processes. Other products on the server may also use SQL (for example, Cayosoft Guardian).
3. Open Command Prompt as Administrator.
4. Run:
   
   Copy

   cd /d "C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances"

5. Run:
   Copy

   ren CayoInstance CayoInstance2

6. NOTE: This renames the CayoInstance folder, effectively removing it from Guardian’s view so it can be recreated.
   

7. If the ren command fails, sqlservr.exe is likely still running and holding the folder. Keep waiting and retrying the command until the rename succeeds.
8. Start the Cayosoft Guardian service.