• With what error? Just saying it's failing isn't much use.

    Maintenance:

    Backups, full maybe diff, probably log depending on RPO and RTO requirements

    Index maintenance

    Integrity checks

    Possible additional statistics maintenance

    Test restores to ensure your backups are useful.

    Alerts configured to tell you before things break

    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