Viewing 15 posts - 7,081 through 7,095 (of 9,244 total)
I would run a server side trace to look for any rogue queries\procedures and monitor file growths, that would be a good starting point
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 8:52 am
just out of interest how large is the database you are moving?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 6:44 am
well i have never bothered myself but if you query the parameter
SERVERPROPERTY('ComputerNamePhysicalNetBIOS')
this returns the actual node name the instance is active on.
Apply some logic and check this for both...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 5:40 am
that is unfortunately a downside of clusters, wasted RAM and possibly even CPU. If you catch the system upon failover and trim the memory back then fine, what happens if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 5:22 am
raguyazhin (5/30/2011)
we migrated our SQL Server Database SQL Server 2000 EE to SQL Server 2005 SP4 EE 64 bit in our Concern.But still our user databases Compatibility Level is 80...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 5:14 am
PhilipC (5/29/2011)
but that just wastes the amount of the RAM in the server to begin with and I don't want to do that.
That's the whole point with clustering. Nodes are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 5:10 am
In that case I would drop and recreate the log shipping scenario.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 30, 2011 at 3:40 am
Regional settings???
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2011 at 7:32 am
what state is the database currently in?
with the standby\undo file missing you wont be able set the database to norecovery or recovery mode if it is in standby mode at...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2011 at 6:30 am
Mark Jones-393934 (5/27/2011)
1. As mentioned by other posters, the requirements are too high scale to allow use of hypervisors.
could you explain a little more what you mean by this
Mark Jones-393934...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2011 at 9:30 am
are you moving the databases across drives on the same server or between servers
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2011 at 11:49 am
it doesn't however mention, Active\Active\Active\Passive.
Next time i build myself an 8 node cluster with 3 passive nodes it'll be an Active\Active\Active\Active\Active\Passive\Passive\Passive
i suppose.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2011 at 10:45 am
as i said, a cluster is either active\active or active\passive irrespective of the number of nodes.
The following article states
Microsoft Technet
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2011 at 9:37 am
Check that the account running the SQL server services has permission to read write the folder specified.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2011 at 5:32 am
Just a couple of points
Firstly there is no such thing as an
Active\active\active\passive cluster.
A cluster is either active\active or active\passive.
Secondly for dev and uat clusters, virtual is the way to go....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2011 at 1:14 am
Viewing 15 posts - 7,081 through 7,095 (of 9,244 total)