Reoccuring Problem
May 9, 2007
This may be a long post so bare with me. I posted a few weeks ago with a SQL issue involving Backup Exec. Long story short I wiped out all SQL on my server and reinstalled Backup exec. It was running fine for about a week and this morning I came in and I can't start the console becasue the services are stopped. I can't start any of them and it is giving me the same errors as before I reloaded. It is a fresh copy of Backup Exec 11d which loads a SQL Express it says. I wiped everything out before the install becasue this is the only thing using sql, after I loaded BE back on I now have in my add/remove programs Micosoft SQL Server 2005, Microsoft SQL Server Native Client, Microsoft SQL Server Setup Support Files, Microsoft SQL Server VSS Writer and also I have MSXML 4.0 SP2 and MSXML 4.0 SP2 Parser/SDK and MSXML 6.0. I had a one time shot with symantec and thats when we reloaded BE and he told me that BE has something to do with MSXML. So this morning I had this in my event viewer Event ID 1000 Faulting application sqlservr.exe, version 2005.90.2047.0, faulting module kernel32.dll, version 5.2.3790.2756, fault address 0x00015e02.
I can't start SQL Server (BKUPEXEC) or SQL Server Browser in my services as they give me the error 1053 The service did not respond to the start or control request in a timely fashion.
What am I doing wrong why did the service just quit in the middle of the night for no reason after working great for a week or so? Is this more of a symantec issue? Thanks for all the help.
View 7 Replies
Jan 18, 2008
Hello,
I'm trying to properly setup a database for re-occuring Inventory Counts, or cycle counts as some call them.
I have a table listing all of the counts, and another table to shows their cycle, i.e. Count1 happens only on Monday and Tuesday, Count2 happens on the 2nd, 15th and 27th day of the month. Once I start recording data for the actual count want to relate that date to a specific occurance of this count, and not to the schedule. In my mind I would create another table that holds the actual counts, seperate from their schedules. My issues is keeping everyting in check, I'm sure there is a proper way of doing it. A good example is Microsoft Outlook and how you can set up re-occuring events or meetings, then you can change one or all of them. That's the type of database structure I'm looking.
If someone can give me any hints or point me to some good reading material that would be great.
Thanks,
View 1 Replies
View Related
Apr 21, 2008
My SQL 2000 server has restarted 12 times since February 29, before then it was pretty stable. The server is an older one and basically it just runs SQL 2000 for three databases, only one of which is busy, but the server as a whole is not overloaded. Operations took the server down last week and ran hardware diagnostics €“ no hardware issues were found. I€™ve checked the system, security and applications logs €“ there are no indications of errors prior to the system restarting. I€™ve checked the SQL logs and there is no pattern to what is running on SQL right before the restarts and there doesn€™t appear to be any correlation between when the server restarts and when SQL jobs, replication agents, DTS packages or database maintenance runs. There are 14 hotfixes which have been applied to the server since January; I€™ve searched Microsoft€™s web site and google for any reported issues with these hotfixes, but haven€™t found any issues reported with them and SQL; I€™d appreciate any assistance in resolving this, thank you.
IBM x-Series 345, dual Xeon 2.00GHz, 2.50 GB RAM
Windows Server 2003 Standard Edition, SP1
Microsoft SQL 2000 SP3 8.00.760
1/22/2008 Windows Server 2003 Hotfix KB941202
1/22/2008 Windows Server 2003 Hotfix KB939653
1/22/2008 Windows Server 2003 Hotfix KB943460
1/29/2008 Windows Server 2003 Hotfix KB930045-v5
2/11/2008 Windows Server 2003 Hotfix KB933729
2/21/2008 Windows Server 2003 Hotfix KB941568
2/21/2008 Windows Server 2003 Hotfix KB944653
2/21/2008 Windows Server 2003 Hotfix KB941569
2/21/2008 Windows Server 2003 Hotfix KB942615
2/21/2008 Windows Server 2003 Hotfix KB941644
2/21/2008 Windows Server 2003 Hotfix KB943485
3/14/2008 Windows Server 2003 Hotfix KB946026
3/14/2008 Windows Server 2003 Hotfix KB943055
3/14/2008 Windows Server 2003 Hotfix KB944533
View 4 Replies
View Related