Viewing 15 posts - 3,751 through 3,765 (of 9,241 total)
looking at the document i linked above its done at the array level. If all LUNs for the instances are carved from the same array (and i'm guessing they are)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 8:07 am
ah i see. You'll need to speak to the storage administrator regarding the SRDF storage fail over
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 7:39 am
It's simples, the only sure fire thing to do when performing the change from windows to mixed is to issue this staright after
ALTER LOGIN [sa] WITH PASSWORD = 'somelongpassword';
ALTER LOGIN...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 7:36 am
PearlJammer1 (1/15/2014)
Find out what is generating the hash\sort warnings and fix it. Just extending TempDB is merely putting a sticky plaster over the real problem.
Would I be best setting...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 6:59 am
SQLisAwE5OmE (1/15/2014)
Perry Whittle (1/15/2014)
SQLisAwE5OmE (1/15/2014)
I have to do a DR test(SRDF), however, one of the application/instance do not want to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 6:57 am
SQLisAwE5OmE (1/15/2014)
I am not too experienced with SRDF, so if you can share your experience, it would be great.
You shouldnt need to be it's ouitside of your control as the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 6:51 am
SQLisAwE5OmE (1/15/2014)
I have to do a DR test(SRDF), however, one of the application/instance do not want to move to DR...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 6:42 am
sql4gnt (1/13/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 6:40 am
you'll need to use linked table manager to relink the tables
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 6:32 am
check connections in the sql server.
Rename the backend Access db 😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 5:31 am
jamessdba (1/15/2014)
Thanks i found this info under logC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log...
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 5:30 am
PearlJammer1 (1/15/2014)
looks like a complicated process to implement. I'm going to have to give this some serious thought.:-):-)
What?
Identitfy the Live tables that require obfuscating (there's likely only a few). Build...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 4:57 am
PearlJammer1 (1/15/2014)
I have sized my 2 tempdb files at 20Gb each because I saw sql monitor returning a lot of sort warning and hash warning alerts - so I figured...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 4:54 am
download the cum13 update and extract it to disk, then run the msi from the extracted folder
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 4:12 am
ramana3327 (1/14/2014)
Hi,I am planning to do clustering in my personal laptop.
See my 3 part guide on this site at the following links
Create virtual cluster Part1[/url]
Create virtual cluster Part2[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 4:01 am
Viewing 15 posts - 3,751 through 3,765 (of 9,241 total)