I've just installed the last version of Sql Server Management Studio 2017 (v17.0) in order to connect to the brand new SQL SERVER vNEXT on Ubuntu 16.04.
So, I tried to restore the classic NORTHWND database, just to test the environment, but the system returned an error.
Although I was using sa login the system gave to me an access permission error to the folder /var/opt/mssql/data/
(where the .bak file reside).
The error message was:
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
I've already check the access of that folder, and it is set correctly to the user mssql, infact if I use SSMS 2014, with the same login, I can restore that database without any problem.
I'm wondering if it isn't a bug of SSMS 2017 after all.
Btw, my configuration is:
the server:
the client:
Thanks for helping!
Seems still not possible restore a database through the UI. But, partially using the UI, I taken in place this old fashioned workaround:
.bak
file into the machine.bak
file, in my env was: RESTORE FILELISTONLY FROM DISK = '/var/opt/mssql/backup/Northwind.bak'
Write down the database name, database filename, log filename and their logical names for using in the next step
Run this command to restore the database
RESTORE DATABASE NORTHWND
FROM DISK = '/var/opt/mssql/backup/Northwind.bak'
WITH MOVE 'Northwind' TO '/var/opt/mssql/data/NORTHWND.mdf',
MOVE 'Northwind_Log' TO '/var/opt/mssql/data/NORTHWND_Log.ldf'
GO
Et voilà, the database was successfully restored!
RESTORE DATABASE
.I keep deeping to find the right solution, for the moment this is enough for me.