Segue os scripts:
BACKUP DATABASE [CORPORERM] TO DISK = N'F:\CORPORERM_backup_2020_03_20_101738_9338263.bak'
WITH NOFORMAT, NOINIT, NAME = N'CORPORERM__backup_2020_03_20_101738_9338263', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'CORPORERM_' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'CORPORERM_' )
if @backupSetId is null begin raiserror(N'Falha na verificação. Informações de backup do banco de dados ''CORPORERM_'' não encontradas.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'F:\CORPORERM_backup_2020_03_20_101738_9338263.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
BACKUP DATABASE [CGW_ContagemWeb] TO DISK = N'F:\CORPORERM_backup_2020_03_20_101738_9338263.bak' WITH NOFORMAT, NOINIT, NAME = N'CORPORERM_backup_2020_03_20_101738_9338263', SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'CORPORERM_' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'CORPORERM_' )
if @backupSetId is null begin raiserror(N'Falha na verificação. Informações de backup do banco de dados ''CORPORERM_'' não encontradas.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'F:\CORPORERM_backup_2020_03_20_101738_9338263.bak' WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
Ai quando começa a executar esta ja de cara retornando o seguinte erro:
Mensagem 1844, Nível 16, Estado 1, Linha 1
BACKUP DATABASE WITH COMPRESSION is not supported on Standard Edition (64-bit).
Mensagem 3013, Nível 16, Estado 1, Linha 1
BACKUP DATABASE is terminating abnormally.
Qual outra forma de gerar bkps menores e compactados?