Backup & Restore in SQLServer Flex

You can take on‑demand backups and restore your SQLServer Flex databases at any time. The platform also creates an automated backup once a day.

Prerequisites

• An active project containing anSQLServer Flex instance.

Create a database backup

via Portal

Portal prerequisites

• (Service) user with permission “sqlserver-flex.backup.trigger” (included in roles “Sqlserver Flex Admin” and “Sqlserver Flex Editor”)

Create a database backup via the Portal

1. Open the project with the SQLServer Flex instance
2. Navigate to the database overview
   1. Select the SQLServer Flex Produkt
   2. Select the SQLServer Flex instance
   3. Select the “Databases” overview
3. In the context menu (at the right end) of the database select “Create Backup”
4. Confirm the database backup creation (The database backup id is not displayed)
5. Validate successful creation of the database backup
   1. Select the “Backups” overview
   2. Expand the entry of the database selected in step 3
   3. Verify that the start timestamp matches with the time of step 4

via API

API prerequisites

• Access token with permission sqlserver-flex.backup.trigger

Create a database backup via the SQLServer Flex API

Submit an on‑demand database backup request with a POST call. Replace the placeholders with the actual values.

Curl example

curl https://mssql-flex-service.api.stackit.cloud/v2/projects/$PROJECT_ID/regions/$REGION/instances/$INSTANCE_ID/backups/databases/$DB_NAME \
-D- \
-X POST \
-H "Authorization: Bearer $TOKEN"
-H "Content-Type: application/json"

More information about the endpoint can be found in the API documentation

Parameter values

Parameter	Description
TOKEN	Valid access token with the sqlserver-flex.backup.trigger permission
PROJECT_ID	Project id where the instance is located
REGION	Region where the instance was createdValid values:eu01eu02
INSTANCE_ID	SQLServer Flex instance id
DB_NAME	Database name used in the SQLServer Flex instance

Response

For an successful created database backup the API responds with a 202 HTTP status code without a payload

API response example

HTTP/2 202
date: Wed, 14 May 2025 14:40:59 GMT
traceparent: 00-4b21c57e6f53d85297efbf01c457e8c2-fefc7e32157b6a1f-01
strict-transport-security: max-age=31536000
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 0; mode=block
content-security-policy: default-src 'self' data: *.stackit.cloud *.stackit.schwarz; style-src 'self' 'unsafe-inline'; connect-src 'self' wss: *.stackit.cloud *.stackit.schwarz; script-src 'self' 'unsafe-eval';
referrer-policy: strict-origin
server: stackit
content-length: 0

Restore a database from a Backup

via Portal

Portal prerequisites

• (Service) user with permission “sqlserver-flex.restore.trigger” (included in roles “Sqlserver Flex Admin” and “Sqlserver Flex Editor”)
• Database to restore doesn’t exist
  Existing databases can’t be restored and have to be deleted beforehand

Restore a database from a backup via the Portal

1. Open the project with the SQLServer Flex instance
2. Navigate to the backup overview
   1. Select the SQLServer Flex Produkt
   2. Select the SQLServer Flex instance
   3. Select the “Backups” overview
3. Expand the database you want to restore
4. In the context menu (at the right end) of the chosen backup click on “Restore”
5. (optional) Configure the desired date and timestamp by activating the checkbox “Restore from a earlier point in Time”
6. Confirm restoration by clicking on “Restore”
7. Wait a few minutes
8. Navigate to the database overview
   1. Select the SQLServer Flex Produkt
   2. Select the SQLServer Flex instance
   3. Select the “Databases” overview
9. The restored database is available 1. If the database is not yet visible, wait another couple of minutes

via API

API prerequisites

• Access token with permission sqlserver-flex.restore.trigger

Restore a database from a backup via the SQLServer Flex API

Submit an on‑demand database restore request with a POST call. Replace the placeholders with the actual values.

Curl example

curl https://mssql-flex-service.api.stackit.cloud/v2/projects/$PROJECT_ID/regions/$REGION/instances/$INSTANCE_ID/backups/databases/$DB_NAME/restore \
-D- \
-X POST \
-H "Authorization: Bearer $TOKEN" \
-H "Content-Type: application/json" \
-d '{
"name": "$DB_NAME",
"restoreDateTime": "$TIMESTAMP"
}'

More information about the endpoint can be found in the API documentation

Parameter values

Parameter	Description
TOKEN	Valid access token with the sqlserver-flex.backup.trigger permission
PROJECT_ID	Project id where the instance is located
REGION	Region where the instance was createdValid values:eu01eu02
INSTANCE_ID	SQLServer Flex instance id
DB_NAME	Database name used in the SQLServer Flex instance If the variable don’t work in the payload replace it with the actual value.
TIMESTAMP	An RFC3339-valid timestamp indicating the time at which the database will be restored. If the variable don’t work in the payload replace it with the actual value.

Response

For an successful created database backup the API responds with a 202 HTTP status code without a payload

API response example

HTTP/2 202
content-type: application/json
date: Mon, 19 May 2025 13:50:15 GMT
traceparent: 00-af8fef938f47d0b56e3fa27c2b02acb2-db976c59cc32de37-01
strict-transport-security: max-age=31536000
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 0; mode=block
content-security-policy: default-src 'self' data: *.stackit.cloud *.stackit.schwarz; style-src 'self' 'unsafe-inline'; connect-src 'self' wss: *.stackit.cloud *.stackit.schwarz; script-src 'self' 'unsafe-eval';
referrer-policy: strict-origin
server: stackit
content-length: 0