/*use "sa" user*/ /*backup*/ BACKUP DATABASE [servicedesk] TO DISK = N'/var/opt/mssql/data/SDDB20230221.BAK'; /*restore*/ ALTER DATABASE [servicedesk] SET OFFLINE WITH ROLLBACK IMMEDIATE; RESTORE DATABASE [servicedesk] FROM DISK = N'/var/opt/mssql/data/SDDB20230221.BAK' WITH REPLACE; /*go online after restore*/ ALTER DATABASE [servicedesk] SET ONLINE;