Viewing 15 posts - 1 through 15 (of 157 total)
We are moving our on-prem instance of Microsoft Dynamics CRM to the cloud version - it's MS so basically Azure. Our head developer gave me a list of things we...
April 2, 2022 at 11:16 pm
Thanks for the link, that's very useful information.
April 1, 2022 at 2:51 pm
Some additional information: I found a fairly consistent "fix" which was renaming the backup set for each database.
Still not clear on *why* that works, though.
February 18, 2022 at 2:35 pm
Brian - thanks for the reply...
January 27, 2022 at 3:05 pm
Thanks.
We're being audited and we have to explain to them why any that aren't encrypted; so for example I actually had to provide evidence that you can't do the master,...
November 10, 2021 at 7:57 pm
Thanks.
One additional question... if I deny these permissions, is it possible to grant them on specific tables, or does the deny override that?
For example, we have a couple of queue...
September 21, 2021 at 5:06 pm
Ack, nevermind... I found the problem...
One of the databases we had to restore after the initial outage was master, and the backup was bad; so it was copied from the...
July 16, 2021 at 1:05 pm
That makes sense.
One thing I ended up trying since I posted was to decrypting one of the databases. I was able to use the wizard normally at that point -...
July 6, 2021 at 9:56 pm
An additional issue...
The restore job on the secondary server is simply skipping over the logs for one of the affected databases. After completing the wizard, I ran the backup job...
July 6, 2021 at 7:51 pm
No hard feelings... been a frustrating week 😀
Thanks for that link; that's a great list.
June 23, 2021 at 5:58 pm
I guess I could come back with "Looks like you need to learn to read." but that would be rude.
I was not asking about SLEEP_BPOOL_FLUSH - I can find plenty...
June 23, 2021 at 12:44 pm
Found the problem - apparently this is a bug in SQL 2019.
2021-06-06 10:30:21.16 The restore operation was successful. Secondary Database: 'FakeName', Number of log backup files restored: 1
2021-06-06 10:30:21.16 ***...
June 6, 2021 at 4:42 pm
Just to follow up, that setting is a life saver.
The process I was having issues with is now running at around 40 seconds consistently, it used to be around a...
May 10, 2021 at 12:53 am
Appreciate the responses 🙂
I had discounted parameter sniffing (perhaps unwisely) because the same job has been running for over ten years on five different GP databases without this issue. One...
May 5, 2021 at 6:46 pm
Ben -
I appreciate the reply. However, in this case the same service account is being used on both servers, and I made sure that the service account had full access...
April 15, 2021 at 7:47 pm
Viewing 15 posts - 1 through 15 (of 157 total)