Post reply

System databases not backing up

  • April 13, 2016 at 3:51 am

    #325634

    Hie i am new on this forum,please advise i do my back ups via a sql server agent job which ecxecutes a stored procedure

    EXECUTE dbo.DatabaseBackup

    @databases = 'SYSTEM_DATABASES',

    @Directory = 'G:\Backups\FULL',

    @BackupType = 'FULL',

    -- @verify = 'Y',

    @Compress = 'Y',

    -- @checksum = 'Y',

    @CleanupTime = 336,

    @LogToTable = 'Y'

    The system databases are not backing up.Thanks in advance

  • April 13, 2016 at 4:01 am

    #1871629

    Are you seeing any errors in the error log?

    Does the job succeed or fail? If fail, with what messages?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 13, 2016 at 5:26 am

    #1871642

    tmmutsetse (4/13/2016)

    Hie i am new on this forum,please advise i do my back ups via a sql server agent job which ecxecutes a stored procedure

    EXECUTE dbo.DatabaseBackup

    @databases = 'SYSTEM_DATABASES',

    @Directory = 'G:\Backups\FULL',

    @BackupType = 'FULL',

    -- @verify = 'Y',

    @Compress = 'Y',

    -- @checksum = 'Y',

    @CleanupTime = 336,

    @LogToTable = 'Y'

    The system databases are not backing up.Thanks in advance

    Check the parameter @databases it will be most probably database names.

  • April 13, 2016 at 5:47 am

    #1871644

    Rechana Rajan (4/13/2016)

    tmmutsetse (4/13/2016)

    Hie i am new on this forum,please advise i do my back ups via a sql server agent job which ecxecutes a stored procedure

    EXECUTE dbo.DatabaseBackup

    @databases = 'SYSTEM_DATABASES',

    @Directory = 'G:\Backups\FULL',

    @BackupType = 'FULL',

    -- @verify = 'Y',

    @Compress = 'Y',

    -- @checksum = 'Y',

    @CleanupTime = 336,

    @LogToTable = 'Y'

    The system databases are not backing up.Thanks in advance

    Check the parameter @databases it will be most probably database names.

    This looks like Ola's backup script. SYSTEM_DATABASES is a valid option there.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 13, 2016 at 5:48 am

    #1871645

    i just made a minor change and tested, i got this error because the directory structure is not there yet, could that be it?

    Msg 50000, Level 16, State 1, Procedure DatabaseBackup, Line 374

    The directory C:\Data\Backups\FULL does not exist.

    when i made sure your command contained a correct path to a folder path, it ran very quickly, and without an error

    EXECUTE dbo.DatabaseBackup

    @databases = 'SYSTEM_DATABASES',

    @Directory = 'C:\Data',

    @BackupType = 'FULL',

    -- @verify = 'Y',

    @Compress = 'Y',

    -- @checksum = 'Y',

    @CleanupTime = 336,

    @LogToTable = 'Y'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 13, 2016 at 11:35 am

    #1871822

    You have 'log to table = y' on.

    OLA scripts keep information about what happened the last time the script ran in a table on Master called 'commandlog', it should have caught any errors and error messages.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply