Middlesbrough
MIS
The following message appears 'DEMO:Full msdb log', do I need to do anything with the log file eg. shrink it. If so can anyone tell me how to do this.
Many thanks
Many thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DEMO: Full msdb log
- Thread starter Middlesbrough
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
- 0
- 36
Unless you've changed the MSDB database it should be in simple recovery mode. This means that the log will be cleared automatically. If you have an unusual amount of data in there I can see the log growing but it should be fairly small. Make sure that your hard drive isn't full. That's the usual cause of this for the system databases.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(Not quite so old any more.)
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(Not quite so old any more.)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question