Viewing 15 posts - 7,696 through 7,710 (of 9,241 total)
To make automatic failover seamless you will need the "Failover Partner=" parameter in the connection string if it's supported. You need to be utilising either SQL native client or ado.net.
For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 2:00 pm
GilaMonster (8/26/2010)
Please note: 2 year old thread.
originally yes, but not now 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 12:27 pm
For SQL Server 2008 the main hive is at the following location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names
If SSRS is installed there will be an RS key in here
If DE is installed there...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 9:24 am
IMHO replication can be even more of a royal PITA, clustering is fairly smooth as long as you know\understand the technology!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 8:44 am
not worried about the database, just need to enumerate the RS instance registry keys on the server where RS is installed, this will provide the info required
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 6:06 am
parthi-1705 (8/25/2010)
It is just the situation that was given to me, it may be due to some more data might have up added additionally or due...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2010 at 3:45 am
Ya, wmi is good but you can get just about any info from the registry ( if you know which keys to find it in) and SQL Server provides a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 10:21 pm
That doesn't really work if the RS database is remote to the RS instance. It also makes assumptions regarding the naming context of the RS database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 8:31 pm
You're welcome 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 8:18 pm
Not just the OS but the version of SQL too. You'll have to select the sql server version and bind to the appropriate keys in the registry!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:46 pm
Not just the OS but the version of SQL too. You'll have to select the sql server version and bind to the appropriate keys in the registry!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:45 pm
You could use xp_regread and parse the RS instance name keys in the registry!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:36 pm
The thing is, in a multi node cluster the passive nodes are patched. The passive node has no active disk resources so it should only ever choose the C drive,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 2:00 pm
I have compared these before and there seems little difference. You can check the comparisons at these links
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx#scalability
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
There are some items in Enterprise only but they werent there in 2005...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 9:00 am
hmm, can't see anything wrong there. At this point i think i would be tempted to stop the ArcSDE services that use the sde user and do the following
1/ Drop...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 25, 2010 at 8:49 am
Viewing 15 posts - 7,696 through 7,710 (of 9,241 total)