When I tried to run the following script, generated by the ‘Back Up Database’ dialog:
BACKUP DATABASE [MigrationSubject] TO DISK = N'\NEWHOMETempMigrationSubject_Full.bak' WITH DESCRIPTION = N'Backup for migration from LEGACYBOX to NEWHOME.', NOFORMAT, NOINIT, NAME = N'MigrationSubject-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10; GO
I received the following error:
Msg 1844, Level 16, State 1, Line 1
BACKUP DATABASE WITH COMPRESSION is not supported on Standard Edition (64-bit).
The solution was to remove the
COMPRESSION option from the
WITH clause, which means the default server setting is used.