Viewing 15 posts - 7,171 through 7,185 (of 9,241 total)
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
The following will get you login names, SIDs and hashed passwords
select name, sid, password_hash from sys.sql_logins
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 3, 2011 at 1:19 pm
check the sql server log again carefully, if the backup command failed it will be in there!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2011 at 3:07 pm
if all the instances are registered under a SQL Server 2008 central management instance use the following query to add the group and assign sysadmin privileges
CREATE LOGIN [domain\group] FROM WINDOWS
EXEC...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2011 at 2:45 pm
Viewing 15 posts - 7,171 through 7,185 (of 9,241 total)