Anyone experience Dr Watson's on MS Cluster Server? This is the second time that it's happened and I can't explian it.
The first time it happened it appeared to stop the virtual server service on my prod server, Cluster admin showed it as running.
This time it bounced the engine but nothing stopped.
Any clue is much appreciated, because I don't have one
I'm at SP5 on NT4 and SP2 on SQL 7 EE.
Pete
SQL Server 7.0
Whenever I attempt to create a new table, or modify an existing one, I get a Dr. Watson, c0000005 (access violation) error.
Any thoughts?
I have been using this code for years but today it is giving me Dr Watson Error "Access Violation" can someone help pls.
BCP PROD_elsie_DB..tblStudent_Info_Temp_Alex in P:elsiedataincomingacapsstu.txt /m 100 /f G:elsieapplsqlcpbstua.fmt /e G:custbasedata
eportsbstuaiw.err /o G:elsiedata
eportsbstuaiw.out /b 1000 /Sdwslc000 /U /P
I'm trying to use bcp to move a table into SQL Server 6.5. The command I am using is bcp CCI..contacts in A:Contacts.txt -fC:contacts.fmt -Usa -P -eC:errors.txt. When executing, I receive the Dr. Watson error message shown here:
Exception: access violation (0xc0000005), Address: 0x77f64d28
If I run DRWTSN32.log it shows the application error to be the following:
c0000005 RtlFreeHeap(77f64d28)
Any ideas why??
I had an error crop up with a DTS package which I need some help with.Error Message :The application, , generated an application error The error occurredon 07/20/2004 @ 06:12:28.203 The exception generated was c0000005 ataddress 41504E2C (<nosymbols>)This happened this morning, but the DTS package runs every 10 minutesand it is the only occurance of this error. Nothing in the DTS packagehas changed and there will not have been any users on the network. I'mas convinced as I can be that the DTS package is fine. Nothing obviousas to what has caused the error, and it hasn't happened again, but Iwould like to understand it more if possible.The closest answer we found was for a SQL2000 error (http://support.microsoft.com/defaul...en-us%3BQ290644 ),but we are running SQL7 (latest sp), so any fix wouldn't apply.The DTS package does a fair amount of importing data and then variousSP's are run to generate a final table of data. From the timing, itlooks to have happened at the end of the process, so would suggestsomething with an SP. Unfortunately, I cannot tell which one. 10minutes after it failed, it worked again and has since, but no-one wasin to correct anything.Any ideas ?ThanksRyan
View 1 Replies View RelatedWell, today's the day. I finally got approved to upgrade our 24x7 cluster to SQL Service Pack 2. I'm so looking forward to running Profiler without causing the server to failover, not to mention ArcserveIt and Spotlight an...
Anyway, Any feedback about the upgrade process is greatly appreciated. I've installed SP2 elsewhere without a hitch but I realize that I have to uncluster my production servers first and that there is no easy way back from SP2. I have full backups scheduled to run prior to the upgrade, any other ways to protect myself? Thanks in advance!!
Pete Karhatsu
Have any one installed SQL Server 7.0 on MSCS in Active/Passive Mode? I need some guidance/Information relating to how to install.
Thanks in advance
Reddy
I am new to MS Cluster server. Could anyone tell me the correct procedure to shutdown and restart MS SQL Server 2000 in a Clustered environment? Thanks
View 1 Replies View RelatedHi
I've recently upgraded 4 sql servers to sp5a and have just found that BCP fails on all of them with a DR Watson error. I did reinstall the Nt sp after installing sql server sp5a.
Can anyone help ?
Thanks
Hello:
We have, on a devlopment server, running a long_running transaction for
almost two days. It was still running. This morning I decided to look at
three of two backup devices under EM to see if any backups were made to
these devices during the last couple of days on a de,mand basis by anyone.
The first one had a backup and the second and third device did not.
Somehow, and for some unexplained reason, the following message was put
into the MSSQL error log (and pretty much the same message went into the NT
event viewer).
----------------------------------------------------------------------
99/02/23 10:05:45.81 kernel dbsvolopen: Backup device
'E:MSSQLBACKUPEaglePro2_run02.DAT' failed to open, operating system
error = 2(The system cannot find the file specified.)
99/02/23 10:05:48.48 kernel dbsvolopen: Backup device
'E:MSSQLBACKUPEaglePro2_run02.DAT' failed to open, operating system
error = 2(The system cannot find the file specified.)
99/02/23 10:05:49.17 kernel dbsvolopen: Backup device
'E:MSSQLBACKUPEaglePro2_run03.DAT' failed to open, operating system
error = 2(The system cannot find the file specified.)
---------------------------------------------------------------------
This error, I beleive, caused DR watson to kick off and we could only sopt
it and revive the long running transaction by rebooting the machine, of
course thus requiring us to restart the lon_running transaction.
It look like NT couldn't find the backup device and therefore activated the
drwatson executible or so it seems to me.
Has anyone experienced this error before? IS it caused by NT? Or that
perhaps a certain threshhold was reacched on NT and drwatson kicked in?Any
other ideas?
Any information that can be provided would be GREATLY appreciated. THanks.
David Spaisman
I need to know if there are any other failover options available for SQL Server/NT, beyond Microsoft Clustered Services. If there are any, which ones are advised?
Thanks,
Jon
jon_waldow@emeraldsolutions.com
Hi I am not having luck creating a linked server on SQL7 running HA on MSCS. We keep getting the "Error 6: Specified SQL server not found"
1. The Linked Server has an advanced entry in the Client Network Utility
2. Setting up the Link to a SQL 7 Server
3. Security is Mapped to a remote user which does exist on the Remote Server.
4. The two machines can ping each other.
5. On the Linking Server the linked Server can be registered as a registered server.
Any Ideas?
Can Linked Servers be set up on M$CS?
-Thanks in advance
-tom
Is it possible to create Fail-over Cluster with 64-bit (Itanium2) and 32-bit (Intel Xeon) nodes?
View 2 Replies View RelatedHello All,
I would like to compare the MSCS with Polyserve's solution and thus wondering if anyone has an experience using both or knows -
What are the major differences between the two?
What are the limitations?
What are the advantages and disadvantages?
Which is advisable to use as a HA solution?
Any other information which may help me to make this decision would be appreciated.
Thanks in advance for your help!
~Managar
How do I install MSDTC in an active/active MSCS cluster environment?
If I run comclust.exe, I can only activate MSDTC on one of the nodes at a time.
I need DTC on both nodes.
(Opsys is W2K with SQL 2000)
//Mange :)