Home > Workload Solutions > SQL Server > White Papers > Solution Insight: SQL Server 2022 Data Analytics on Dell PowerEdge with AMD EPYC 7473X Processors and Dell ECS > Backup and restore use case
SQL Server 2022 can run backup and restore operations using T-SQL. This feature allows database administrators (DBAs) to send backups of SQL databases to S3-compatible storage in addition to the traditional backup method. With the scalability of Dell ECS object storage, DBAs do not have to worry about running out of storage capacity.
A Dell ECS credential is required to backup SQL Server databases to Dell ECS on the SQL Server instance. This credential permits the S3 connection between the SQL Server instance and the object storage. After creating the credential, run the backup operation using T-SQL command with the TO URL syntax.
Create credential inside SQL Server instance for connection to S3 storage with storage URL and user credentials.
Figure 9. Create ECS storage credential at SQL Server instance
Perform a backup of a database to ECS storage.
Figure 10. Perform backup operation
For a restore operation, use the FROM URL syntax. This syntax can also be used to verify whether the backup files are available on the object storage before doing the actual restoration. To verify, run the “RESTORE FILELISTONLY FROM URL = ‘s3://path/filename’” command.
To perform a restore operation, run the RESTORE DATABASE <DBname> FROM URL = ‘s3://path/filename’ script with other operations.
Figure 11 shows an example for performing the verification process before the restore operation.
Figure 11. Backup file verification
Perform SQL Server database restore where FROM URL points to storage location for backup file. All other options should not be changed.
Figure 12. Restore database from ECS Storage
More information about backup and restore using T-SQL, see these documents from Microsoft.