I am experimenting with crate and I am at the backup/restore point.
I have managed to take a backup:
CREATE repository snapshots type fs WITH (location=‘snapshots’, compress=true);
CREATE snapshot snapshots.all_tables ALL WITH (wait_for_completion=true);
And now I want to copy the backup files and restore them to a different crate server.
I have tried the obvious, copy the files to the appropriate repo directory on other server and the create the repository with the same statement as above but the “SELECT * from sys.snapshots limit 100;” does not return the snapshot.
Is there any way to make it work?