Hi
We are dealing with a major crash which meant we had to restore our MS SQL database from 6 months ago.
One person tries to log in, and they are told they need to perform a database update, which is fine and they can't because of permissions.
On my system I appear to have all of the recent entries. I don't have 'offline' enabled but I have intelligent caching.
My question is - what I am currently seeing appears to be much more recent than 6 months ago, so I think my system has a cached copy of the database from just before it crashed. I think my machine is seeing the database and that is why it is opening, but it is not showing me the (now old) live SQL entries, it is showing me the cached version.
Is there a way I can save/export the entries as they appear on my machine, because they are much newer than the restored SQL database, and then import them back to SQL?
Hope this makes sense.
I am running v12.0.8.0 and on the other computer the database says the current version is 284.
Hello,
Do tou have access to the File - Export menu? Its possible to export all the entries from there if the menu is available.
Best regards,
Jeff Dagenais
Hi Jeff
Yes I do.
What format is best, and will I lose anything?
Thanks
Jon
"Export All entries (.rdm)" is your best bet. Make sure you check "Include Credentials" & "Include Security Groups"
A quick note to let you know what you are seeing. Since you have intelligent caching enable RDM uses some smarts when talking with the server. The reason you are seeing the newer version is they are still present in your RDM instance is due to the cache. We first load from cache then ask the server for "new" information. In this case since the server was restored from a 6 month old backup it won't return anything (as expected).
Now before you do anything, make a backup of your intelligent cache file. Should be called "offline.mcdf2" in a folder here: %LOCALAPPDATA%\Devolutions\RemoteDesktopManager\
Once this file is deleted you will have lost all chances of recovering the last 6 months of data.
Keep in mind many actions in RDM will cause your cache file to be deleted, changing users settings for example.
Best regards,
Stéfane Lavergne
Thanks Stefane
There was no 'include security groups' but I did not tick 'remove all groups', only 'Credentials'.
I have backed up the whole Devolutions folder from localappdata.
So now how is best to proceed - I guess I need to upgrade the database and then restore the RDM backup file?
If it makes a difference, we are planning to move this to a cloud storage, I am looking at either Devolutions Online Server or Azure SQL. Is there any benefit of using the Devolutions offering over Azure? I think we get Azure credits from Microsoft so we may not have to pay much/any for it, and I see the Devolutions basic solution is limited to 3 users, which isn't a problem for us just yet but may be shortly.
So what I am saying is - should I just go ahead with the cloud database setup and then restore my RDM backup file into it, rather than wasting time with SQL which we are going to ditch soon?
Thanks so much for your fast help.
Both options have pros/cons. Accessing your SQL Azure DB from new IP will require you enable the IP in SQL Azure firewall or use RDM in offline mode until you get back to the office. Cloud on the other hand will simply work as long as you have access to the internet. The cost of Cloud is higher since you already have Azure credits. With Cloud you have to SQL server to manage. You get the idea. (https://help.remotedesktopmanager.com/index.html?datasource_types.htm)
As for getting you back up and running. I would follow these steps.
- Start RDM, let it perform the DB upgrade
- Import all sessions into the database
- Perform a cache refresh on each user machine (CTRL+Refresh) this will clear the client cache and re-sync it with the server versions so that things can now sync properly for now on
- create & schedule a backup ;-)
Best regards,
Stéfane Lavergne
I just wanted to thank you and let you know that your advice was spot-on, we are back up and running again and yes I have setup an online backup of the SQL database :)
Thanks for your advice on cloud, we will have a think about it.
Hi
I have in a same situation. My installed RDM 12.0.8.0 has crashed. it's not starting, so I can not export data. The problem related to MS C++ Redis package, and I did not find any solution for the problem.
Now I decided to uninstall and then install again the Remote Desktop Manager, maybe this help.
in this case, my saved credentials and sessions (connections) remains?
How can I recover important files from existing installation?
@Nabi,
I have response to you via this topic - https://forum.devolutions.net/topic28374-remote-desktop-manager--support.aspx?lastpage=1
Best regards,
Jeff Dagenais
@Jeff
Thank you, but I think it is not bad to know the recovery procedure.
Is there any way?
Hello,
In RDM, the data is saved in what we called a Data Source. The data source can be local (SQLite or XML), cloud based (Devolutions Online Drive, Devolutions Online Database or SQL Azure) or you can use a on-premise centralized data source (SQL Server, MySQL, MariaDB or Devolutions Server).
If you are using a local data source, the data source is saved in %localappdata%\Devolutions\RemoteDesktopManager.
The application configuration are saved in the same folder in a file called RemoteDesktopManager.cfg.
That being said, if you want to backup the configuration of RDM as well as your local data sources, I suggest to backup the entire RemoteDesktopManager folder located in %localappdata%\Devolutions.
Best regards,
Jeff Dagenais