SQL Server Performance

ALTER DATABASE dbName SET RECOVERY SIMPLE in SQL7

Discussion in 'General Developer Questions' started by onclezeb, Jun 21, 2004.

  1. onclezeb New Member

    hi !

    I need to set the recovery mode to simple on an SQL 7 with TSQL.
    On SQL 2000, the TSQL commande : "ALTER DATABASE dbName SET RECOVERY SIMPLE" works well.
    But not in SQL7...
    Is there a solution to set, in TSQL, the recovery mode to simple (or full) in sql7 ?

    OncleZeb
  2. satya Moderator

    SP_DBOPTION 'dbname','trunc. log on chkpt','TRUE'

    Refer to books online (always) as a first hand help for the syntax.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. onclezeb New Member

    Thanks a lot !!
    It's ok

    OncleZeb

Share This Page