Home Forums SQL Server 2008 SQL Server 2008 Administration Possible to use Policies to force ad-hoc backups to be copy_only? RE: Possible to use Policies to force ad-hoc backups to be copy_only?

  • March 9, 2013 at 8:43 pm

    #1595275

    Michael Valentine Jones (3/8/2013)

    I suggest not giving people permissions to do backups, ands setup a job they can execute that does the copy only backup.

    This would be my inclination as well.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events