mssql action

mssql action

/opt/mssql-tools/bin/sqlcmd -S  localhost -U SA -P 'RUNrundao!@#..' -Q 'RESTORE FILELISTONLY FROM DISK = "/var/opt/mssql/data/NantongWeigang.bak"' | tr -s ' ' | cut -d ' ' -f 1-2


/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P 'RUNrundao!@#..' -Q 'RESTORE DATABASE NantongWeigang FROM DISK = "/var/opt/mssql/data/NantongWeigang.bak"'


sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
   -S localhost -U SA -P '<YourNewStrong!Passw0rd>' \
   -Q 'RESTORE DATABASE WideWorldImporters FROM DISK = "/var/opt/mssql/backup/wwi.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"'


//在docker 中附加数据库文件
EXEC  sp_attach_db  @dbname  =  '你的数据库名',
@filename1  =  'mdf文件路径（包缀名）',
@filename2  =  'Ldf文件路径（包缀名）'