[{"_1":2,"_153":-5,"_154":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_132":133},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":11},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_125":-5,"_126":11,"_127":17,"_128":11,"_129":-5,"_130":131},"canonicalUrl","https://hub.docker.com/r/boshoffwillem/sql-server/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","boshoffwillem","reponame","sql-server","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2021-07-28T09:08:05.54553Z","description","SQL Server 2019 image","is_private","last_updated","2021-07-28T09:12:39.322015Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",233,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","# How to use\n\nThere are two ways of spinning up the container:\n\n- Clean container with no existing data\n- Import existing data into a container\n\nThree environment variables are needed when creating the container.\n\n```txt\nACCEPT_EULA=Y\nSA_PASSWORD=\nMSSQL_PID= (default: Developer)\n```\n\n- Developer: This will run the container using the Developer Edition (this is the default if no MSSQL_PID environment variable is supplied)\n- Express: This will run the container using the Express Edition\n- Standard: This will run the container using the Standard Edition\n- Enterprise: This will run the container using the Enterprise Edition\n- EnterpriseCore: This will run the container using the Enterprise edition Core\n\n## 1. Spinning up a clean container with no existing data\n\n```bash\ndocker container run -e \"ACCEPT_EULA=Y\" -e \"SA_PASSWORD=\" -e \"MSSQL_PID=Developer\" -p :1433 --name sqlserver boshoffwillem/sql-server:latest\n```\n\nYou'll probably want to persist the SQL data of the container in case the container crashes. Just start the container and bind the data to a volume (docker will create the volume if it doesn't exist).\n\n```bash\ndocker container run -e \"ACCEPT_EULA=Y\" -e \"SA_PASSWORD=\" -e \"MSSQL_PID=Developer\" -p :1433 --name sqlserver -v :/var/opt/mssql boshoffwillem/sql-server:latest\n```\n\n## 2. If you have existing SQL data\n\nIf you want to import existing SQL data you have into the container you're going to spin up follow these steps:\n\n### 2.1 Create backup files of your existing SQL data\n\nAt the least, you need the .bak file of each DB you want to import into the container.\n\n### 2.2 Create the container\n\n```bash\ndocker container run -e \"ACCEPT_EULA=Y\" -e \"SA_PASSWORD=\" -e \"MSSQL_PID=Developer\" -p :1433 --name sqlserver -v :/var/opt/mssql boshoffwillem/sql-server:latest\n```\n\n### 2.3 Copy backup files into container\n\n```bask\ndocker cp .bak :/var/opt/mssql/backup\n```\n\n### 2.4 Execute query to restore the backup files\n\nYou'll need to execute the following query to tell SQL Server to import the backup files. The easiest way to do it is to connect to the server with a DB program like Azure Data Studio. The connection string will be **hostname,port**\n\nFor example\n\nlocalhost,11433\n\n```sql\nRESTORE FILELISTONLY \nFROM DISK = '/var/opt/mssql/backup/.bak'\n```\n\n### 2.5 Execute query to restore the DB\n\nThe following query will create a DB from the backup file.\n\n```sql\nRESTORE FILELISTONLY \nFROM DISK = '/var/opt/mssql/backup/.bak'\n\nRESTORE DATABASE \nFROM DISK = '/var/opt/mssql/backup/.bak'\nWITH \n MOVE '' TO '/var/opt/mssql/data/.mdf',\n MOVE '_Log' TO '/var/opt/mssql/data/.ldf'\n```\n\n## 3. Backup SQL data in the container\n\nIf you want to create backup files for the SQL data in your container, execute the following query.\n\n```sql\nBACKUP DATABASE [] \nTO DISK = N'/var/opt/mssql/backup/.bak' \nWITH NOFORMAT, \nNOINIT, \nNAME = '', SKIP, NOREWIND, NOUNLOAD, STATS = 10\n```\n\n### 3.1 Copy DB backup out of the container\n\n```bash\ndocker cp :/var/opt/mssql/backup/.bak .bak\n```\n","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",494092903,"orgData","recentTags",[87],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",9229673,"full_size",494086505,"id",160138006,"images",[97],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":92,"_59":62,"_113":-5},"architecture","amd64","digest","sha256:f67bcb4529cb9a70c5278b5f168470ca5864fc7f75917d2bc5c9e47d43d7142b","features","","last_pulled","2026-08-24T09:25:22.107508898Z","last_pushed","2021-06-13T16:52:52Z","os","linux","os_features","os_version","size","variant","2021-07-28T09:12:38.964817Z","last_updater","last_updater_username","media_type","latest","repository",14994628,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":134,"_141":142,"_130":151,"_152":11},{"_36":135,"_38":136,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":137,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":138,"_75":11,"_76":140,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":139},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_143":60,"_144":-5,"_145":-5,"_146":147},"count","next","previous","results",[148],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":149,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[150],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":92,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

boshoffwillem/sql-server

Tags for boshoffwillem/sql-server