• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • 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?
1 Solution
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'

cheng77Author Commented:
i can succesfully run the command, but when back to the properties of the database. the truncation log size still not reduce
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.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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