直接上干货:
#拉取阿里云镜像
docker pull registry.cn-hangzhou.aliyuncs.com/newbe36524/server:2019-latest
#镜像重命名
docker tag registry.cn-hangzhou.aliyuncs.com/newbe36524/server:2019-latest mcr.microsoft.com/mssql/server:2019-latest
#给文件夹授权
cd /mnt/data1/gim-analy/software/sqlserver
chown -R 10001:0 ./sqlserver2019_data/
#拷贝数据到文件夹
#启动容器
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_PID=HMWJ3-KY3J2-NMVD7-KG4JR-X2G8G" -e "MSSQL_SA_PASSWORD=Saver@123" --name SqlServer2019 -p 2433:1433 -v /mnt/data1/gim-analy/software/sqlserver/sqlserver2019_data:/var/opt/mssql -d mcr.microsoft.com/mssql/server:2019-latest
#工具连接sqlserver,并执行脚本
EXEC sp_attach_db @dbname = 'WindDB',
@filename1 = '/var/opt/mssql/WindDB.ndf',
@filename2 = '/var/opt/mssql/WindDB_log.ldf'