?
Solved

error message checkpoint

Posted on 2006-07-13
6
Medium Priority
?
617 Views
Last Modified: 2011-10-03
in my logs today i get
Automatic checkpointing is disabled in database 'QuestSoftware' because the log is out of space. It will continue when the database owner successfully checkpoints the database. Free up some space or extend the database and then run the CHECKPOINT statement.

I just changed the log to automatically grew was on 251 mg and the database is on simple mode....how do i do checkpoint just for the QuestSoftware

0
Comment
Question by:TRACEYMARY
  • 4
  • 2
6 Comments
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 17100741
Is this a production database?
0
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 17100764
I guess if its Quest its ok to be in simple recovery...
is this SQL Server 7 or 2000?
0
 
LVL 13

Accepted Solution

by:
Atlanta_Mike earned 2000 total points
ID: 17100777
Also, what service pack are you on?

http://support.microsoft.com/kb/909369/
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17103528
Yes live production database but quest is its own software for monitoring SQL...
service pack 2 ...... i read i needed 4.......but not got that on there yet.

2000
0
 
LVL 13

Expert Comment

by:Atlanta_Mike
ID: 17107961
Yes, I know Quest, they have some pretty good tools...
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17108365
We have the trial just got order for new one i let you know if its any good...i do like to know the sql commands aswell though...
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question