Sqlcmd - Revision history

Busk at 04:10, 3 February 2024

2024-02-03T04:10:07Z

Busk at 04:08, 3 February 2024

2024-02-03T04:08:48Z

Busk: 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"

2024-02-01T23:54:18Z

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"

New page

# 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

@@ Line 23: / Line 23: @@
    REPLACE; -- Use REPLACE if the database already exists
 GO
 ```

← Older revision		Revision as of 04:08, 3 February 2024
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
		+	```