Viewing 15 posts - 7,171 through 7,185 (of 9,244 total)
about the only use for multiple log files would be the following type of scenario
You have your database log file on drive D:
The drive runs out of space
You have free...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2011 at 5:25 am
fail.gary (4/6/2011)
A Active / Passive
B Passive...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2011 at 5:13 pm
personally, i still prefer a freenas or openfiler VM for the virtual storage for my virtual systems
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2011 at 5:05 pm
build the clustered instance on your new hardware and migrate the databases across to the cluster from the stand alone machine
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2011 at 4:57 pm
what does the following return when executed against the sql instance
SELECT
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS PhysicalNodeName,
SERVERPROPERTY('ServerName') AS ClusteredInstName,
SERVERPROPERTY('IsClustered') AS IsClustered
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2011 at 4:55 pm
Windows 2003 or 2008 cluster?
firstly confirm that both nodes can communicate with each other over public and private connections.
What has changed since the passive node was operational, check your change...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2011 at 4:47 pm
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2011 at 8:13 am
only the master database and the error log location are held in the registry along with default data and log and backup paths. Tempdb location is taken from the master...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 5, 2011 at 3:00 am
no, i put "" around the url which is ok for Safari but IE doesnt like it :crazy:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 8:33 am
should be now
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 8:21 am
Windows 2008 clusters no longer use a domain account it runs as local system.
See the following KB from Microsoft for further info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 8:15 am
M.Kahn (4/4/2011)
You mean i have to login every server and run that syntax or
Yes, pretty much or alternatively
As i said if you have SQL Server 2008 central management server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 8:09 am
my apologies i have fixed the link now
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 8:08 am
M.Kahn (4/3/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 6:17 am
EvilPostIT (7/19/2010)
I'll take that as a no then...
How many filegroups\files do you currently have in use for this database?
Toothpicker (4/3/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2011 at 6:10 am
Viewing 15 posts - 7,171 through 7,185 (of 9,244 total)