• Phil4860 (2/18/2014)


    It had changed itself to Restricted File Growth (MB) 2,097,152.

    I changed this again to Unrestricted and it resets itself to the Restricted File Growth (MB) settings above.

    That's normal, That's also 2 TB, I do hope you don't have a 2TB log file.

    Can you try taking a native backup, not via some app just a plain BACKUP DATABASE ... and see what messages you get?

    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