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?
cheng77Asked:
Who is Participating?
 
ctcampbellConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.