The server principal "XYZ\USER" is not able to access the database "YourDBName" under the current security context.How to export SSIS package ( dtsx file) from SSISDB.RESTORE DATABASE WideWorldImporters FROM DISK = '/var/opt/mssql/backup/WideWorldImporters-Full.bak' WITH MOVE 'WWI_Primary' TO '/var/opt/mssql/data/WideWorldImporters.mdf', MOVE 'WWI_UserData' TO '/var/opt/mssql/data/WideWorldImporters_userdata.ndf', MOVE 'WWI_Log' TO '/var/opt/mssql/data/WideWorldImporters.ldf', MOVE 'WWI_InMemory_Data_1' TO '/var/opt/mssql/data/WideWorldImporters_InMemory_Data_1' Restore FILELISTONLY FROM disk = '/var/opt/mssql/backup/WideWorldImporters-Full.bak' Use below command in SQL Client to list database files –.Use docker cp to copy the backup file into the container in the /var/opt/mssql/backup directory.Sudo docker exec -it MSSQLDB mkdir /var/opt/mssql/backup The following command creates a /var/opt/mssql/backup directory inside the SQL Server container.
use docker exec to create a backup folder.Copy backup file of WideWorldImporters.Step 2 – Connect to SQL Server with SQL Client (dbeaver) Step 3 – Restore sample database WideWorldImporters
0 kommentar(er)
