Troubleshooting

Installation

Installation failed

This usually happens when the installed service cannot start. Check the Application section of the Windows Event Viewer for extra information.

"Error 1923. Service 'Redgate SQL Clone Agent' (Redgate SQL Clone Agent) could not be installed.  Verify that you have sufficient privileges to install system services."

This can also mean a service with that name already exists. Ensure any previous SQL Clone installations are removed, and try again.

Trouble creating an image for the first time

If you have installed any previous version of SQL Clone, ensure you have a clean starting state by:

• Removing all clones within the application, and deleting the folder "localappdata%\Red Gate\SQL Clone\clones"
• Removing all images within the application, and deleting any files left on disk
• Uninstalling the old version
• Rebooting the machine
• Ensuring that there are no services called "Redgate SQL Clone" or "Redgate SQL Clone Agent"

Creating an image

The requested operation could not be completed due to a file system limitation (Win32Exception)

Ensure the image destination you chose has more free space than the size of your database, and ensure the disk is defragmented.

I can see failed images on Web UI and I cannot delete them

Unfortunately, we don't currently have a way to clear out the failed items on the Web UI. However, we are aware of this restrictions and it's on our backlog to get it done. As a workaround, you can run the below update command against our config database. it will mark those failed images as deleted. Please make sure that the database name reflects the database name that you configured it to. It's "SQLClone_Config" by default.

UPDATE [SQLClone_Config].[dbo].[Images] SET [State] = 4, DeletedOn = GETUTCDATE()
WHERE [State] = 6 AND DeletedOn IS NULL;