Viewing 15 posts - 6,721 through 6,735 (of 9,241 total)
parissa_bakhshi (8/28/2011)
I don't Use multipathing.
doing so would provide more performance and redundancy.
parissa_bakhshi (8/28/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2011 at 2:45 am
BrentMc (8/28/2011)
use the EncryptByKey and DecryptByKey functions.
you may also use certificates (DecryptByCert and EncryptByCert) and asymmetric keys (DecryptByAsymKey and EncryptByAsymKey)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2011 at 4:18 pm
what is the recovery model of the database for which you want to remove the extra file?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2011 at 12:17 pm
exactly which wait type are you seeing, can you provide a sample?
can you provide more detail on your iscsi setup, what initiator software are you using, do you have multiple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2011 at 12:09 pm
You all sorted now?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2011 at 7:47 am
shew (8/27/2011)
the attachment had some volume 2 (20 GB) and initiator 2 stuff in it. Did I miss something?
No, vol2 is an extra volume I am using
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2011 at 8:32 am
Dude you're almost there. Remember the volume is the parent the dataset nests under the volume. It is daunting at first but once you grasped it you'll be golden.
Create extents...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2011 at 7:40 am
shew (8/27/2011)
the second vol1 as "/mnt/vol1/SQL" under the first vol1 "/mnt/vo1".
That's the ZFS dataset. Where you create the volume there is another option to create a dataset. SQL is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2011 at 6:51 am
shew (8/27/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2011 at 6:47 am
may i ask why you dont want to cluster MSDTC??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2011 at 3:36 am
Hi Shew
so far you are good, you must create the volume and then select the option to create a ZFS dataset. See the attached short doc for more info and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2011 at 3:10 am
to change endpoint users you run this against the mirror and the principal
GRANT CONNECT ON ENDPOINT::Mirroring TO [XXXXX\XXXXXX]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2011 at 1:25 pm
didnt we already discuss this at the link below?
http://www.sqlservercentral.com/Forums/Topic1165352-146-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2011 at 12:05 pm
colin.Leversuch-Roberts (8/26/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2011 at 10:49 am
my point is, you want them on disk long enough for them to be persisted to tape, after that delete them!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2011 at 10:44 am
Viewing 15 posts - 6,721 through 6,735 (of 9,241 total)