/*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;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter