Viewing 15 posts - 31 through 45 (of 9,244 total)
A better option would be to point the op to the stairway on this site
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 28, 2025 at 6:18 am
************To update the password of master key************
ALTER MASTER KEY ADD ENCRYPTION BY PASSWORD = 'NewStrongPassword!';
not necessary or advisable either!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2025 at 6:51 pm
7. Restore master key
RESTORE MASTER KEY FROM FILE = 'C:\Backup\MasterKey.bak'
DECRYPTION BY PASSWORD = 'BackupPassword'
ENCRYPTION BY PASSWORD = 'NewPassword';
to clarify if the restore is on the same server the above...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 27, 2025 at 6:48 pm
Thanks for your offline idea, and for sp_who2.
It was "Something" from Redgate that caused the trouble. I have uninstalled, and used your trick, and the db is up and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 3:28 pm
depends on your current licence model, but yes you'll need a licenced edition for each replica.
If you have enterprise agreement with software assurance you can get licence concessions for availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 12:08 pm
We are self hosting sql servers, we are not using Azure for sql servers. and we would like to do encryption on data that is at rest for multiple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 10:38 am
a little more info on the AWS config would be nice, such as type and cpu resource allocation.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 10:33 am
and theyre definitely sql user not db or app role or some other entity?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 10:28 am
Basic AG supports only 2 replicas with 1 database, you can have a listener in basic AG.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 10:26 am
what was the original version of this database, im guessing it came from a very early version.
You're saying you dropped all users from the database but sysusers still shows 2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 10:22 am
Now if we just talk about one server, if somehow the DMK got corrupted on the server, not sure what could cause that happen,
im not sure either, you’re...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 17, 2025 at 7:05 am
Thank you Perry, sorry for the typo, corrected. This answers my question clearly, I see some articles asked to backup DMK and save it to a safe place, not...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2025 at 10:21 pm
Hi Peter and others,
btw who’s Peter?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2025 at 8:18 pm
Hi Peter and others,
So it sounds we just create DMK on each server instead of using restore backup of DMK from another server? since you mentioned ensure the DMK...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 16, 2025 at 8:16 pm
What networking restrictions are there in place, there are a number of ports required for the nodes to fully communicate, are there any firewall devices
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 7, 2024 at 6:58 am
Viewing 15 posts - 31 through 45 (of 9,244 total)