Difference between revisions of "Sqlcmd"
Jump to navigation
Jump to search
(Created page with "# backup ``` sqlcmd -S 10.x.x.x -U sa -P ${PASS} -d master -Q "BACKUP DATABASE demo TO DISK='C:\Temp\demo.bak' WITH COPY_ONLY" ``` - WITH FORMAT") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
- WITH FORMAT | - WITH FORMAT | ||
| + | |||
| + | |||
| + | # Backup Restore | ||
| + | |||
| + | List DB Logical Names | ||
| + | ``` | ||
| + | RESTORE FILELISTONLY FROM DISK = '/bkp/mydb.bak'; | ||
| + | ``` | ||
| + | |||
| + | Restore in container | ||
| + | ``` | ||
| + | RESTORE DATABASE mydb | ||
| + | FROM DISK = '/bkp/file.bak' | ||
| + | WITH | ||
| + | MOVE 'mydb' TO '/var/opt/mssql/data/mydb.mdf', | ||
| + | MOVE 'mydb_log' TO '/var/opt/mssql/data/mydb.ldf', | ||
| + | REPLACE; -- Use REPLACE if the database already exists | ||
| + | GO | ||
| + | ``` | ||
| + | |||
| + | |||
| + | # Docker Compose MSSQL | ||
| + | ``` | ||
| + | version: '3.2' | ||
| + | |||
| + | services: | ||
| + | mssql: | ||
| + | image: mcr.microsoft.com/mssql/server:2022-latest | ||
| + | restart: unless-stopped | ||
| + | ports: | ||
| + | - "1433:1433" | ||
| + | environment: | ||
| + | - ACCEPT_EULA=Y | ||
| + | - SA_PASSWORD=foobar | ||
| + | - TZ=US/Denver | ||
| + | - MSSQL_PID=Express | ||
| + | volumes: | ||
| + | - "./bkp/:/var/opt/mssql/data/" | ||
| + | - "./data/:/var/opt/mssql/data/" | ||
| + | - "./log/:/var/opt/mssql/log/" | ||
| + | - "./secrets/:/var/opt/mssql/secrets/" | ||
| + | ``` | ||
Latest revision as of 04:10, 3 February 2024
backup
sqlcmd -S 10.x.x.x -U sa -P ${PASS} -d master -Q "BACKUP DATABASE demo TO DISK='C:\Temp\demo.bak' WITH COPY_ONLY"
- WITH FORMAT
Backup Restore
List DB Logical Names
RESTORE FILELISTONLY FROM DISK = '/bkp/mydb.bak';
Restore in container
RESTORE DATABASE mydb FROM DISK = '/bkp/file.bak' WITH MOVE 'mydb' TO '/var/opt/mssql/data/mydb.mdf', MOVE 'mydb_log' TO '/var/opt/mssql/data/mydb.ldf', REPLACE; -- Use REPLACE if the database already exists GO
Docker Compose MSSQL
version: '3.2'
services:
mssql:
image: mcr.microsoft.com/mssql/server:2022-latest
restart: unless-stopped
ports:
- "1433:1433"
environment:
- ACCEPT_EULA=Y
- SA_PASSWORD=foobar
- TZ=US/Denver
- MSSQL_PID=Express
volumes:
- "./bkp/:/var/opt/mssql/data/"
- "./data/:/var/opt/mssql/data/"
- "./log/:/var/opt/mssql/log/"
- "./secrets/:/var/opt/mssql/secrets/"