Viewing 15 posts - 5,476 through 5,490 (of 9,244 total)
Thomas Stringer (6/10/2012)
Is that port (5024) blocked?
On the same server, no.
But it could be in use by either the principal or mirror instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2012 at 2:49 pm
Jai-SQL DBA (6/10/2012)
Gila lets take a Scenerio :There are 3 file groups for My db
Primary
Secondary
Log
are all talking scenario here or the actual configuration of your database?
As Gail...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2012 at 9:16 am
can you provide a little more detail on your setup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 10, 2012 at 9:14 am
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
Viewing 15 posts - 5,476 through 5,490 (of 9,244 total)