Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1. docker pull mcr.microsoft.com/mssql/server:2017-latest
- 2. docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>' \
- --name 'sql1' -p 1401:1433 \
- -v sql1data:/var/opt/mssql \
- -d mcr.microsoft.com/mssql/server:2017-latest
- 3. docker exec -it sql1 mkdir /var/opt/mssql/backup
- 4. docker cp us_national_statistics.bak sql1:/var/opt/mssql/backup
- 5. docker exec -it sql1 "bash"
- 6. /opt/mssql-tools/bin/sqlcmd -S localhost -U SA [The password is: <YourStrong!Passw0rd>]
- 7. RESTORE DATABASE US_NATIONAL_COPY FROM DISK = "/var/opt/mssql/backup/us_national_statistics.bak" WITH REPLACE, RECOVERY, MOVE "us_national_statistics" TO "/var/opt/mssql/data/usns_copy.mdf", MOVE "us_national_statistics_log" TO "/var/opt/mssql/data/usns_copy.ldf";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement