If you need to change to a new machine, it's possible to move the SQL Servers that are already registered in SQL Backup to a new server, without re-registering them in the SQL Backup graphical user interface (GUI).
- Locate a file called servers.dat which is normally in this path:
C:\Users\<User Name>\AppData\Roaming\Red Gate\SQL Backup
where <User Name> of the user that has the servers registered in their GUI.
This file contains the connection information for each server you have registered.
- Close the SQL Backup GUI on your new workstation.
- Copy the server.dat file from your old workstation to your new workstation in the same folder path above (if the user who will be using the GUI is different change <User Name>).
- On your new workstation, navigate to this path:
C:\Users<User Name>\AppData\Local\Red Gate\SQL Backup\Server Data\
(again for the user who is using the GUI).
- You will find 2 or more .dat files, for example, 1.dat, 53.dat, localDataCache.dat. Delete all of the .dat files located here - do not worry, new files will be created when you open the GUI in the next step.
- Now open the SQL Backup GUI, it will populate the registered servers from the copied servers.dat file and create the .dat file deleted in the previous steps.
2
0
Was this article helpful?
1 out of 2 found this helpful
Articles in this section
- Resolving Error 507 and SQL Error 18456 in PCC Backup Restores
- SQL Backup error 605
- SQL Backup Error: Cannot access resource
- SQL Error 3203
- Error - Cannot load the DLL xp_sqlbackup.dll, or one of the DLLs it references
- Failed to obtain the list of cluster nodes
- Log Copy Queue is stuck in SQL Backup
- SQL Backup Network Share Permissions Test
- SQL Backup troubleshooting
- Errors when running a scheduled job with SQL Backup