Viewing 15 posts - 106 through 120 (of 2,854 total)
Another thought - are you running the backup with the UNC path and FQDN OR are you trying to backup to a drive letter?
Backup to a drive letter will likely...
September 12, 2024 at 4:33 pm
Just to add, I believe you also need RPC OUT enabled on the linked server in order to execute stored procedures on a remote system as well.
September 12, 2024 at 2:33 pm
Just wanted to add that SSIS lets you use code (scripting in C# if I remember right), so if the functionality is missing in native SSIS, you can build your...
September 12, 2024 at 2:31 pm
Thinking this MAY be working as designed. As per the documentation for the parameter StatisticsModificationLevel:
Specify a percentage of modified rows for when the statistics should be updated. Statistics will also...
September 12, 2024 at 2:26 pm
If the execution plans are the same, then that is weird that performance is different with the AO on and off, especially with async enabled as AO should just push...
September 12, 2024 at 2:16 pm
Another reason why you may be stuck at 2019 on server1 is supported OS. I know my SQL instances are stuck on older versions due to the OS version, but...
September 11, 2024 at 2:57 pm
My opinion (like I stated above and like Ken implied) is that query hints are RARELY needed. There are use cases for them, and I do use "OPTIMIZE FOR" more...
September 11, 2024 at 2:40 pm
My opinion - query hints are rarely best practice and often lead to other issues.
If I understand things right, you are taking out an exclusive lock on table 1 when...
September 10, 2024 at 7:54 pm
If changing code is a no go, is adding code OK?
If so, you could set up a linked server from A to B and then set up a trigger on...
September 10, 2024 at 7:48 pm
Quick google brought me this:
The master key is used to encrypt and decrypt sensitive data, such as credentials, that are stored in the database. If the master key is missing...
September 9, 2024 at 7:24 pm
Linked server I think is the only option, but personally, I'd refrain from doing something like this. My style is to keep my stored procedures contained to the system they...
September 9, 2024 at 7:19 pm
SQL won't associate the view with the linked server. You will need to update the code to tell it to use the linked server. IF you break the single system...
September 9, 2024 at 7:13 pm
My GUESS is since you have implicit transactions turned on, the delete is happening in batches and the "sync" is only happening AFTER the transaction completes. So if you are...
September 9, 2024 at 5:34 pm
I'm not sure about your response. Did you configure the SPN's or not? If you didn't, I would configure the SPN's. If you have configured the SPN's, then my next...
September 4, 2024 at 8:26 pm
Sounds like an SPN issue. Did you configure the SPN's?
September 4, 2024 at 5:47 pm
Viewing 15 posts - 106 through 120 (of 2,854 total)