We installed SQL 2008 two nodes failover cluster on WinServer 2003. If it was sql 2000, we should have to configure licensing through ControlPanel...
Hello, Two days ago I started to receive this error in my SQL Server log file. I see this kind of error first time in three years. It shows up every...
I use profiler. It is a powerfull tool, but I cann't find what I want. Tried to make the filter regarding to ObjectID, but it seems it doesn't work-...
SQL Server Cluster Windows Server 2003 SQL Server SP4 2 active nodes Interesting thing has happened. There was a need to restart SQL server...
Hello, we have win2k3 sp1 and SQL2000 SP4. The problem is that I cann't to force MSDTC to come online. The short review of what I do and what I...
Today in the morning when I got to my workplace I noticed through EM that one of the our Prod SQL servers doesn't work. I have tried to connect to it...
After SQL Server option change we got this error. SQL server didn't allow any client connections and the only way to bring it to normal work was the...
We are linking a SQL2000 server to an Access DB. We have set this up no problem on a normal SQL2K server - works like a treat. However, when we...
Hello, Cluster is running on two nodes with win2003 and sql2000. I have a couple questions: 1.Is it possible to break cluster into separate...
Hello, I have the following problem: On server S1 I've made linked server MS to Microsoft Access database with the following scripts: EXEC...
One question: How to drop all USER defined indexes from database at once? There are about 2300 of them Thanks in advance
We have a lot of refferenced views to other server and now we need to change server name into other. Does anyone know any way to change for IE:...
Does anyone know how to clean the buffer cache earlier than it reaches the max size? In theory the cache holds inactive pages while buffer cache...
We have 2 nodes sql 2000 server cluster on Windows2003. The problem is when in QA I try to connect to virtual SQL server and typing IP address the...
Installing 2 sql server instances in a cluster do I need two IP of these servers in different subnets or in the same? Thanks in advance
There are three nodes: S1, S2, S3. S3 is designated almost for log shipping only(standby server). S1 and S2 are sql 2000 servers and they are in the...
Hello all, It's my first time when I got such task. I need to configure active/active 2 node sql server cluster on win2003 server. I've read a lot...
Hello all, There are two sql 2000 servers on one domain. The primary server (Srv1) hosts a db1 and the secondary server(Srv2) copies and restores...
Separate names with a comma.
