Viewing 15 posts - 4,501 through 4,515 (of 9,244 total)
They read the MS kb did they 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 2:19 pm
Ok but generally you would want at least 2 or 3 NICs teamed for your public connection to provide redundancy.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 11:50 am
Have you used network teaming before??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 8:48 am
Can you post the table definitions for the tables you are deleting from?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 5:46 am
sql-lover (12/3/2012)
-We are using cross over cable for heartbeat
As i said a segregated network
sql-lover (12/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 4, 2012 at 1:49 am
sqlfriends (12/3/2012)
Can I use dynamic port for the named instance,
When I install the named instance, and check the tcp\ip port, it defaults to blank, with dynamic port set to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 11:54 pm
Oops good catch Lynn I didn't spot that port number there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 11:47 pm
sqlfriends (12/3/2012)
Do I have to configure the named instance to use diffrent port than 1433 because the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 4:32 pm
sql-lover (12/3/2012)
My bad, we all know 3 is what we need ... 🙂
No, not necessarily. It all depends on your network infrastructure and your redundancy requirements.
sql-lover (12/3/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 4:29 pm
The wmi comsole is pretty good here. The problem with xp_fixeddrives is it cant return mounted volume details. Use something along the lines of
wmic volume get capacity, "free space", name
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 1:47 pm
sql-lover (12/3/2012)
I'm having a hard time to convince IT team that we don't need so many NICs in a dedicated SQL cluster. Besides SAN, I usually use two NICs only,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 1:39 pm
It's now WSFC and it is indeed part of the Windows 2008 server Enterprise and Datacenter editions.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 1:36 pm
Ratheesh.K.Nair (12/3/2012)
Perry how can we achieve that? If did ,it is having high chance for corrupting the backup right.
Not at all, I've never had an issue with the backup converter
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 11:45 am
HildaJ (12/3/2012)
I need to restored the master db file from one of my red gate backup files. I'd like to know the required steps to do this.thank you.
The easiest...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 8:36 am
ravi@sql (12/3/2012)
ya maxsize is given for autogrowth
What are the size details for the log currently?
Do you have any long running transactions?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 3, 2012 at 6:03 am
Viewing 15 posts - 4,501 through 4,515 (of 9,244 total)