Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

How to configure Simple recovery model in SQL 7

IN SQL2000, i can use simple recovery model to reduce transaction log. How to do in SQL 7?
0
cheng77
Asked:
cheng77
1 Solution
 
ctcampbellCommented:
From the Books Online on simple recovery in SQL Server 2000:

This model is similar to setting the "trunc. log on chkpt." database option in Microsoft® SQL Server™ version 7.0 or earlier.

trunc. log on chkpt.: When true, a checkpoint truncates the inactive part of the log when the database is in log truncate mode.


EXEC sp_dboption @dbname = 'database name',
    @optname = 'trunc. log on chkpt.',
    @optvalue = 'TRUE'

0
 
cheng77Author Commented:
i can succesfully run the command, but when back to the properties of the database. the truncation log size still not reduce
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now