Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Alter Database DBNAME Set Recovery Full. Gives error. RE: Alter Database DBNAME Set Recovery Full. Gives error.

  • February 23, 2009 at 12:49 am

    #948451

    swmsan (2/22/2009)

    Alter Database DBNAME Set Recovery Full.

    I get error 'Incorrect syntax near FULL.

    The syntax is correct. Is that all that was in the query window?

    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