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.

   • Optionally, check Task Manager for sqlservr.exe running under the System account.

   • Do not stop all sqlservr.exe processes. Other products on the server may also use SQL, such as Cayosoft Administrator.

3. Open Command Prompt as an 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

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

6. If the ren command fails, sqlservr.exe is likely still running and holding the folder. Wait and retry the command until the rename succeeds.

7. Start the Cayosoft Guardian service.

If the instance is not recreated automatically

If the LocalDB instance contained only Archive databases, Cayosoft Guardian may not recreate the instance automatically. In this case, create the instance manually by running the following command from a Command Prompt running as Local System:

sqllocaldb create CayoInstance

NOTE: You can use PsTools (PsExec) to run Command Prompt as Local System.

Re-register Archive databases

Archive databases are not automatically registered on the newly created instance. To register them again:

1. Locate the database files. The default folder is:

   Copy

   C:\ProgramData\Cayo Software\Guardian\database

2. In Cayosoft Guardian, navigate to Settings > Archive Databases.

3. Select the Archive database and click Remove. If it was the default Archive database, select the Deregister checkbox.

4. Click + New.

5. Specify the following SQL server name:

   Copy

   (LocalDb)\CayoInstance

6. Enter the database name. For example:

   Copy

   CayoArchive

7. In the additional connection parameters, enter:

   Copy

   AttachDbFileName=[path to the database file]

   For example:

   Copy

   AttachDbFileName=C:\ProgramData\Cayo Software\Guardian\database\CayoArchive.mdf

    

8. Keep the Create if not present checkbox selected.