| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Index Corruption in SQL 2000-Urgent Posted by bijupg NO[at]SPAM hotmail.com at 8/28/2006 2:09:01 AM Dear ALL,
I am running sql 2000 (sp3 a) on a cluster (comopaq) with database located
in a raid 10 array .
it was woking properly since 2002 but recently i getting lot of index
corruption around 5 corruptions in this month and all rectified by recreating
the corrupted indexes . but it is happ...more >>
Load balance Posted by Casper Hornstrup at 8/27/2006 12:00:00 AM Hi.
My application is based on ASP.NET 2.0 and SQL Server 2005. Most of my
data-processing happen on the SQL Server (in two stored procedures written
in C#) - the webserver don't do much in this setup. I'm investigating ways
to have load balancing of the data-processing accross multiple (ph...more >>
Transactions done twice during failover Posted by Avi at 8/27/2006 12:00:00 AM Hi experts,
I'm running replication from SQL Server 2000 to Sybase. Whenever I do a
failover from one node to the other I get duplicate rows. That means that
certain transactions are done twice.
What can I do to avoid that?
Thanks a million,
Avi
...more >>
Fulltext failure on a 2 node cluster Posted by frankm at 8/25/2006 3:56:34 PM We have a 2 node windows 2003 enterprise edition cluster (S01 and S02).
-2 sql servers running in 2 different virtual servers (V01 and V02).
-The V01 SQL Server's preferred node is S01 and the V02 SQL Server's
preferred node is S02.
-On V01 one database has fulltext catalogs.
-When the V01 v...more >>
How to change service accounts on a cluster Posted by tootsuite NO[at]SPAM gmail.com at 8/25/2006 3:23:36 PM Hello,
Need help. Have 2005 SQL Server cluster... I need to change the service
accounts for SQL Server, SQL Server Agent, etc to a non-administrator
domain user.
What is the correct way to do this? From which node do I change the
service accounts? Do I need to change them on both nodes?
...more >>
SQL Server 2005 Analysis Services Clustering Posted by Karthik Vatsan at 8/25/2006 2:34:15 PM Hi,
I have setup a 2 node clustering (Active/Active) of SQL Server 2005 (IA64)
on windows server 2003 (IA64) ..Now i am planning to add Analysis Services
on this cluster.
My question is if i have to add the analysis services as a cluster aware
application, do i need to have another IP addr...more >>
Demonstration of Failover Capabilities Posted by vihrea at 8/25/2006 11:21:02 AM I'd like to find a program that clearly demonstrates how SQL 2005 failover
works
(flawlessly). This application would be used to show that a failure can
occur and users are not impacted by that failure.
This program would:
1) execute a datareader to page through a query displaying its da...more >>
Clustering - basic question Posted by Karthik at 8/25/2006 5:49:01 AM Hi,
I am newbie to SQL Server and Clustering as such. I would like to perform a
SQL Server install over a cluster.
For this will a machine having Win 2k Professional and 2 * 100 GB hard disks
suffice? Will the Cluster service be available with Win 2k prof?
Also, can any one point me to...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server Fulltext resource is not starting Posted by SreeV at 8/24/2006 4:46:01 PM Hi,
SQL Server Fulltext resource is deleted from resource group when i add back
the SQL Server Fulltext resource its not coming online any pointers?
Thanks,
Sree...more >>
TDS vs. TCP Posted by Ayad at 8/24/2006 2:29:37 PM Hi,
I have 2 SQL 2000 Ent. instance, one is stand alone (test) and the other
instance is on Cluster (production) (W2K3).
I have an application perfomance issue, the application runs ok on test but
it is slow on production. I took a network capture for both instances and
anlyzed the commu...more >>
Move SQL 2000 data to new SAN, same drive letter Posted by Ken at 8/22/2006 5:15:49 PM We need to move our existing SQL 2000 data to a new SAN.
If I move/copy the database files to the new SAN but remap to the same
drive letter, do I need to perform a detach/attach of the databases?
Assume the databases will be offline. The cluster node running SQL will
remain untouched apart ...more >>
password change for sql account Posted by ILYA at 8/22/2006 2:56:02 PM Hello,
I had to change domain administrator password. SQL 2000 on WIN 2003 cluster
is running on domain administrator account. After i changed password i cannot
get into Enterprise Manager with windows autentication. I did not restart sql
server or cluster, just changed the password for SQL a...more >>
SQL Clustering Posted by drsherw at 8/22/2006 9:42:02 AM Can SQL be virtualized and then clustered on separate host servers? Or do
the virutal servers have to exist on the same host? What I am asking is can
virutal servers be clustered on separate hardware?
Thank you in advance....more >>
Hardware for sql 2005 cluster Posted by bijupg NO[at]SPAM hotmail.com at 8/22/2006 5:32:02 AM Hi,
we are palnning to aquire new Cluster hardware for sql 2005 on win dows 2003.
database size 10 gb.active/passive cluster.
pls advice best suited hardware model
what about DL 380 G5 WITH MAS 1000?
note: Price is not a constraint.
rgds
Biju...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |