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 22, 2009 at 11:16 pm

    #948432

    swmsan (2/22/2009)

    Dear All,

    I installed SQL Server 2005 in my home PC. SQL server 2000 was allready existing.

    I installed SQL 2005 without installing SQL 2000. Will it make any difference..?

    No, it should not make any difference.

    Now am facing some problem with below command.

    Alter Database DBNAME Set Recovery Full.

    I get error 'Incorrect syntax near FULL.

    What could be the problem..? Pls help.

    What are you trying to do here?