search

microsoft / mssql-docker

Official Microsoft repository for SQL Server in Docker resources
MIT License
1.73k stars 758 forks source link

Restore database via SSMS, cannot change path #460

Open daleqq opened 5 years ago

daleqq commented 5 years ago

When trying to restore a backup via SSMS with latest 2017 version, I change the path then returned following error. I had checked the access right, all are same and should be the default access right. error

forkazmoden commented 5 years ago

Hi,

I've got the same error when I tried to change the path even if I ran SSMS as administrator. So I'd prefer to use T-SQL to restore the database. Please refer to RESTORE Statements (Transact-SQL).

RESTORE DATABASE AdventureWorks2012
FROM DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak'
WITH RECOVERY
daleqq commented 5 years ago

Hi,

I've got the same error when I tried to change the path even if I ran SSMS as administrator. So I'd prefer to use T-SQL to restore the database. Please refer to RESTORE Statements (Transact-SQL).

RESTORE DATABASE AdventureWorks2012
FROM DISK = 'Z:\SQLServerBackups\AdventureWorks2012.bak'
WITH RECOVERY

Hi, thanks for your comment. As you said, either use T-SQL or SQLCMD should work. But I have another image which is 2017-CU4 don't have this problem.

Beakster commented 5 years ago

Hi, this seems like the same issue I'm experiencing. Did you ever find a solution? I'm sticking to running the old images as the new ones all seem to have this bug. https://github.com/microsoft/mssql-docker/issues/475