Thanks, arunyadav for the reply. I found out that configuration of licensing on SQL local server is not required anymore. This is not sql server...
We installed SQL 2008 two nodes failover cluster on WinServer 2003. If it was sql 2000, we should have to configure licensing through ControlPanel...
Thanks Sat, it looks the problem is solved! We have MS System Center Operation Manager 2007 installed and after the last update during the last...
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...
Have you tried "DBCC DBREINDEX"? As BOL says: "DBCC DBREINDEX rebuilds an index for a table or all indexes defined for a table. By allowing an...
It's just information message(Severity 1), you may not pay attention to it.
http://support.microsoft.com/kb/314515
You cannot shrink database files when using Modify File option. Please look, what says BOL: "If SIZE is specified, the new size must be larger than...
quote:Originally posted by sns_subash2002@yahoo.com Can any one help me like how many IP are required when we sare using 3 noted(2 active/1 passive)...
Adriaan, do you have any thoughts regarding to this?
I thought about that. But I couldn't find the way how to get the name of SP, which updated the records
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-...
Thanks Satya for really important and usefull info. I think this link should help me in the future To clarify the situation I would like to make one...
Clients got an error which stated "Server not found".
SQL Server Cluster Windows Server 2003 SQL Server SP4 2 active nodes Interesting thing has happened. There was a need to restart SQL server...
mulhall, Yes, that's clear for me. I just want to be sure, that after stopping the cluster service on both nodes I'll be able to start the cluster...
Manual? So if I correctly understood, after Node1 restart the cluster service on that node wouldn't start. If I will stop the cluster service on the...
Thank you for your posts! Argyle, I wanted to check couple points: 1. What cluster service startup type should be when taking all these actions...
You need one SP per virtual instance. If you have activeactive and pasive cluster you'll need two sp on two virtual sql server instances. Not...
There you can find all you need: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_5h6b.asp Cheers
Separate names with a comma.
