.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

SQL Cluster Fails Over at the Same Time Every Day

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
 
System Info 2 node active passive cluster running sql server 2005 standard edition OS:   Windows 2008 Server Enterprise SP1 Hardware:  Dell 2950 dual quad core processors 32gb ram both server are identical in hardware configuration Database drives are iscsi connections to and emc celera san The last set of windows updates were done on 8/1/2010 to bring it current on updates   Every day right around 6am the cluster will fail over, every time it starts with errors about corruption on 1 of the san drives, takes the drive offline to run chkdsk, and then immediately has errors that the private connection between the 2 boxes is down.    it then fails over and runs fine until the next day at 6am, this has been occuring for the past 4 days.  No other jobs or anything are running at the time of the failover. Any ideas.  Thanks in advance.    


View Complete Post


More Related Resource Links

SQL Server 2008 Agent Fails to start in a Win 2008 Cluster

  
When I try to bring SQLAGENT Online, I get the following errors: EventID:53 [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1 [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] OnlineThread: Error 435 bringing resource online.   I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

SQL 2008 CLUSTER INSTALL FAILS USING COMMAND LINE WITH CONFIGURATIONFILE.INI

  
Platform:   2 servers (clustered) with windows server 2008 x64 r2 (enterprise) Application: sql2008 x64 enterprise with SP1 (slip streamed) Problem: sql2008 new cluster install fails using the COMMAND LINE with a CONFIGURATIONFILE.INI The install starts but stops with the log file in the setup bootstrap folder  => (Detail_ComponentUpdate.txt) below. Bottom lines indicate a REBOOT is required; did a reboot on both nodes and still have the same problem. Used the following command line to launch sql2008 setup: Setup.exe /Q /SQLSVCPASSWORD="**********" /AGTSVCPASSWORD="**********" /ASSVCPASSWORD="**********" /ISSVCPASSWORD="**********" /RSSVCPASSWORD="**********" /ConfigurationFile=ConfigurationFile.ini Anyone has any success installing sql2008 using command line and command file? thanks john ------------------------------- tail end of the Detail_ComponentUpdate.txt file ----------------------------------------------- 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59:44 Slp: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x64.exe exit code: 0 2010-09-01 15:59:44 Slp: Launching external tool: C:\SQL2008 Enterprise with SP1\x64\FixSqlRegistryKey_x86.exe 2010-09-01 15:59:44 Slp: ------------------------------------------------------------ 2010-09-01 15:59

Adding second node to SQL Server cluster fails.

  
I have successfully created a MSCS cluster and I have the SQL cluster up and running on the first node.   When I put the install cd in the second node and go through the install it fails with the error SQL Server Setup has encountered the following error:  Object reference not set to an instance of an object. I'm assuming I get this error because on the cluster node configuration screen the "cluster network name" box is blank.   It won't let me select a name or type a name. The SQL cluster is up and running on the first node.   I can ping the sql cluster network name from both boxes.   The setup shows the installed node and the node I"m trying to add, so I don't see any problem. I have Windows 2008 R2 on both nodes and I'm installing SQL Server 2008 R2.   Any idea how I can get past this error?    Thank you.

Adding thrid Node to SS2K8 cluster fails on adding fileshare

  
I am attempting to add a third node to a two node cluster. I am using the SS2K8 SP1 slipstream I used to successfully install the other two nodes. The new node of the cluster is:  Hardware: Dell R610 blade  OS: Windows Server 2008 R2 Enterprise 64 bit SQL: SQL Server 2008 SP1 64 bit Enterprise. The two node system has been running for months without problems. How do I fix a failure to add a file share for filestream because the value of group was null (Bold Italics below)? I have not found anything on the web that addresses this problem. Brad The bootstrap summary file woes content(s): Detailed results:   Feature:                       Database Engine Services   Status:                        Failed: see logs for details   MSI status:                    Passed   Configuration status:          Failed: see details below   Configuration error code:      0x11428655   Configuration error description: Value cannot be null.  Parameter name: group &nbs

SQLDIAG fails in SQL Server 2008 Cluster environment.

  

SQLDIAG failing with following errors in SQL Server 2008 cluster environment:

SQLDIAG Error opening Software key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG . Function result: 87. Message: The p

SQL 2008 Single Node cluster installation fails on Windows 2008

  

Environment:
SQL Server 2008 Enterprise Edition 64 Bit
Windows 2008 64 Bit SP2

SQL installation failed with this error message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error

Please let me know what the issue is.

I found 2 solutions in net:

1. Add new registry key named DisableLoopbackcheck under "HKLM\SYSTEM\CurrentControlSet\Control\Lsa\" and set to value 1

2. Set server principal name


determining cluster failover time from SQL log

  
I need to be able to determine when a SQL cluster failover took place.  I don't have access to the cluster log.  I only have access to the SQL logs.  What specific message indicates a failover?  Or is there another way to tell (from SQL side).  SQL 2005 or 2008.  Thanks.

Installation of dot Net Framework 4 fails every time.on 64 bit Vista. have tried everything!

  

Running Vista basic 64 bit, service pack 2.. have used the verification tool to verify all the dot net frameworks from 1.1 to 3.5.. passed

used the clean up utility to remove  framework 4.. it says it was successful but appears to still be there..i.e. i can 'remove' framework 4 five times in a row  (!)

It appears that the record of 'failed' windows update attempts for .net4 go back all the way to febuary.. so it's not anything recent.. 

The error is code 643, which would (IIRC) imply that i have not got all the service packs installed, but I do, and unlike the way it used to be, you can't re-install a service pack without uninstalling it first..

Since I am concerned that the bug that won't allow installation of .net 4 would manifest some othewr unexpected place if i tried reinstalling a sevice pack, i don't want to go the uninsstall/reinstall route unless i *really* have to...

Frankly i'm at a loss..

Anyone?


Round off time to the nearest minute

  
How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

  
Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.

Date and Time Functions in SQLSERVER

  
Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
4 GETDATE and GETUTCDATE Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

  
Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

How to programmatically add controls to Windows forms at run time by using Visual C#

  
Create a Windows Forms Application
Start Visual Studio .NET or Visual Studio 2005 or a later version, and create a new Visual C# Windows Application project named WinControls. Form1 is added to the project by default.
Double-click Form1 to create and view the Form1_Load event procedure.
Add private instance variables to the Form1 class to work with common Windows controls. The Form1 class starts as follows:

.NET 4 Web Application Startup Time

  
I was chatting with Jonathan Hawkins and some of the folks on the ASP.NET team about performance and Jonathan mentioned the startup time for large ASP.NET applications is improved on .NET 4. There are some improvements in the CLR and in ASP.NET itself that helped. If you have a giant app, you should do some tests.

Built-in Functions - Date and Time Functions

  
Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

Essential SQL Server Date, Time and DateTime Functions

  
The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.

Date/Time Conversions Using SQL Server

  
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend