Post reply

Log ship primary DB has log 2x large as datafile

  • May 22, 2017 at 10:30 am

    #323712

    Hi all,

    I've checked the log ship backup job is working fine. 

    Any ideas on next steps?

    Thanks,

    JB

  • May 22, 2017 at 10:33 am

    #1943595

    what is the status of this database when checking 

    Select name, log_reuse_wait_desc from sys.databases

    is the log shipping backup job succeeding?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • May 22, 2017 at 11:51 am

    #1943614

    Also DBCC SQLPERF(LOGSPACE). Perhaps it just filled up due to something wierd but is now mostly empty.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 3 posts - 1 through 2 (of 2 total)

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