Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-28 : 08:14:37
|
| Strongweb writes "Guys, hoe you can help me out here. I've a got a weird situation.Last month, we upgraded our server to include an extra 3 harddisks (RAID-5).So now it has a total of 6 disks (RAID 5) with a total space of 96GB. Two days after the installation, my SQL scheduled events stops working. After another week, my jobs began to run again suddenly. Is there some settings that need to be changed when you add in new disks to the system?. I checked the NT log and found these two errors.[sqlserveragent]Unable to read local eventlog (reason. The event log file has changed between readsafter that[sqlserveragent] sucessfully re-opened the local eventlog: some events may have been missed.Any input is appreciated..." |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-28 : 12:07:25
|
| No, You shouldn't have to change any settings.Is there only one occurance of this problem, or is it happening a lot? Are there any peculiar errors in your event logs? This error by itself is nothing to be alarmed about, it will occur if another process has the log files locked when sqlagent tries to write to them.-Chad |
 |
|
|
|
|
|
SQLserveragent behaving misteriously