Viewing 15 posts - 6,721 through 6,735 (of 9,244 total)
It's still unclear what you are trying to achieve, are you wanting to change the database owner?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2011 at 10:39 am
shew (8/29/2011)
Thanks, that helps a lot. I plan to check this out after I get home from work.
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2011 at 3:15 am
shew (8/28/2011)
Perry,Networking is not a strong point for me (I normally use DHCP at home, and IP assignment is performed by a different group at work).
🙂 hey no worries. Again...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 29, 2011 at 3:05 am
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
Viewing 15 posts - 6,721 through 6,735 (of 9,244 total)