Hi, What do you mean by 'You can SOMETIMES uninstall the service packs through add/remove program, at other times you'd have to restore the box from...
Hi, I want to know the dates when different Service Packs for SQL Server and Windows Server has been installed on my system and with which account....
Hi, Thanks for your reply. Yea I was able to select the records from that table with (nolock) but nothing else could be done at that moment. And I...
Hi, I have Windows 2000 Advanced Server with SP4 and SQL Server 2000 Enterprise Edition with SP3a. I have SQL Cluster (Active-Passive) environment....
Yes for sure. Thank you Luis. And Satya by the way I would like to know something about "lightweight pooling" mode (fiber mode). Can you please give...
Yipppeeeeeeeeeeee.................... Reinstallation of SP3a has done the trick. But dont know how... Regards, Manoj Verma DBA
One more interesting thing is that when I create Transaction Log Backup through Maintenance Plan then its working but at its scheduled time only,...
Well I also went through many articles on the net and found that the problem could be that SQL server is running in "lightweight pooling" mode (fiber...
No changes to SQL Server have been done since a month. And I have gone through that article also which Luis have specified but there is nothing...
Thats the main issue that there is nothing in SQLAgent error log too. This is the information I am getting in SQLAgent log: [101] SQL Server MANNU...
Just tried that too but didnt work. Regards, Manoj Verma DBA
Hi, I just tried to make a job which takes the full backup but its also not working. Same problem is there with it also. And one thing as I mentioned...
Hi Satya, Well SQL Server Agent service account is a part of local admin and is also a part of sa role in SQL Server. And I m having SQL 2000 with...
well I also hope that some one else could help me out in this particular issue... Regards, Manoj Verma DBA
When I say error log then it means the same as u said as well as the Error Log files in the default SQL Instal location and Windows Event Viewer too....
No there is no error at all. I restarted the SQL Services & Agent Services many times but it never gave any error. Regards, Manoj Verma DBA
I am having SQL 2000 with SP3a on Windows 2000 Standard Server with SP4. And there is no entry in event viewer even except one that is "SuperSocket...
Whenever I try to run the job through Database Maintenance Plan and it does not run at all. And If I try to run it manually then it actually does...
Separate names with a comma.
