Advertisement
avisrivastava254084

Untitled

Sep 15th, 2019
557
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. 1. docker pull mcr.microsoft.com/mssql/server:2017-latest
  2. 2. docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>' \
  3. --name 'sql1' -p 1401:1433 \
  4. -v sql1data:/var/opt/mssql \
  5. -d mcr.microsoft.com/mssql/server:2017-latest
  6. 3. docker exec -it sql1 mkdir /var/opt/mssql/backup
  7. 4. docker cp us_national_statistics.bak sql1:/var/opt/mssql/backup
  8. 5. docker exec -it sql1 "bash"
  9. 6. /opt/mssql-tools/bin/sqlcmd -S localhost -U SA [The password is: <YourStrong!Passw0rd>]
  10. 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