none
Erro ao gerar bkp sql server 2008 RRS feed

  • Pergunta

  • 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?

    sexta-feira, 20 de março de 2020 15:32

Todas as Respostas