Viewing 15 posts - 196 through 210 (of 9,244 total)
I also spotted that the managed service offsite backup vendor that is in use had changed their scheduling slightly in the last week, and that their backup schedule was...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 25, 2024 at 10:43 am
Bear in mind that the user who owns the database maps in via the dbo database user and can do all that members of db_owner role can do
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 9:36 pm
The databases are using TDE or column level encryption?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 9:28 pm
also run the following and supply the query results
select name, is_master_key_encrypted_by_server
from sys.databases
where name='ssisdb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 6:54 pm
have you created a security policy, cant see code example below, might be worth reading this before you go any further
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 6:09 pm
need more info on the source A database, anything obvious in the logs?
Here are some articles on 824 and 825 error that may help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 6:04 pm
We're a hosting company but the end-user/customer has a DBA who manages these servers so I'll get him to query the sys.credentials catalog for any backup to URL related...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 12:26 pm
Recommend you try again and go through in detail following the relevant sections
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 11:59 am
Hi Perry,
Thanks for the reply. I'm not much of a SQL guy so I'm not sure how to go about "query the sys.credentials catalog for any backup to URL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 11:48 am
Which guide you use
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 10:57 am
Seems to be steps missing there.
have you confirmed you can open the master key on the source and the destination
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 10:04 am
The only custom CDC alerting I have done for sql agent jobs is around AG failover what parameters are you currently targeting
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 24, 2024 at 4:41 am
I will see where i get on and feedback to let you know how i got on.
important to understand the encryption hierarchy, each time a project\package is created and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 8:03 pm
So we have no issue logging into the the instance at all, the setup is pretty much as it was before i migrated. The issue only arises when I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 5:03 pm
the kerberos SPN tool is very useful here, heres the link for future reference
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 23, 2024 at 3:53 pm
Viewing 15 posts - 196 through 210 (of 9,244 total)