Viewing 15 posts - 5,476 through 5,490 (of 9,241 total)
to change the actual node name uninstall any clustered instances from that node then remove the node from the cluster.
Rename and reboot and then re join to the cluster, then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2012 at 8:59 am
great, you can also slipstream during setup, see my tutorial at this link[/url] for info on how to do this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2012 at 6:47 am
cfradenburg (6/7/2012)
-- Clear Wait Stats
-- DBCC...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2012 at 6:05 am
Jpotucek (6/7/2012)
Sharepoint really should be in it's own Named Instance and I have another application that requires it's own instance because of a special SQL Server collation that it requires.
That's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 7, 2012 at 4:44 am
Hi
Run the following against your secondary database and check the column value for "restore_mode".
exec sp_help_log_shipping_secondary_database
@secondary_database = 'secondary_database_name'
To change the secondary database config use
EXEC master.dbo.sp_change_log_shipping_secondary_database
@secondary_database = 'secondary_database_name'
,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 5:51 pm
Where as I just use wmi from a central instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 5:05 pm
Yes, SQL 2000 doesn't support mount points anyway so that's fine. You'll need to use xp_fixeddrives to get the free space and disk name
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 3:52 pm
Ah that's ok then, you're running SQL server 2000 on this box?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 3:30 pm
opc.three (6/6/2012)
Win32_Volume is not a class on all the servers that I support.
Which OS\service pack?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 2:48 pm
As already mentioned, take this opportunity to ramp up the CPU and RAM.
Aside from that, would there be any mileage\possibility consolidating the remaining instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 2:42 pm
best way, the way i use, is a WMI command line query, this will catch logical drives and mounted volumes too as it looks at the volume level 😉
You can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 12:46 pm
Vertigo44 (6/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 12:27 pm
Chris Golla (6/6/2012)
but you can restore your 2005 msdb onto your 2008 sql server overtop the one currently there.
do not do this!
the msdb holds information relative to the sql server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 12:25 pm
Nicholas Cain (6/6/2012)
Standard edition limits you to a failover pair of nodes (versus up to 16 with Enterprise Edition) and it's not a "hot standby" situation.
Note, this does not affect...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 11:38 am
charipg (6/6/2012)
is there any problem if i stop?
it's hosed already so it won't make an ounce of difference 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 6, 2012 at 11:35 am
Viewing 15 posts - 5,476 through 5,490 (of 9,241 total)