Viewing 15 posts - 1 through 15 (of 1,171 total)
I'm ready for the structure of going back to the office more days per week. But I dislike open office plans, so I'm glad to be able to work in...
April 24, 2024 at 7:44 pm
EDIT: Actually, this thread seems to arrive at your conclusion (Error 19406 being all you need) but I suggest reading through those other articles too anyway. HTH
https://www.sqlservercentral.com/forums/topic/alwayson-availability-failover-
Hi,
You can...
April 10, 2024 at 7:05 pm
Hi, are you looking for something like this?
https://www.mssqltips.com/sqlservertip/2235/creating-backups-and-copies-of-your-sql-azure-databases/
HTH
-- webrunner
April 4, 2024 at 2:24 pm
Thanks for this fascinating info and for the book rec!
-- webrunner
February 10, 2024 at 4:30 pm
Same here. I thought there were two viable answers here.
-- webrunner
January 5, 2024 at 5:31 pm
Thanks, Steve, for the question. I wonder, though, if master is in Full recovery, but its log can't be backed up, does the log file just keep growing?
Thanks again.
-- webrunner
December 12, 2023 at 8:27 pm
OK, was just wondering. Thanks!
-- webrunner
August 11, 2023 at 3:09 pm
Thank you both for the advice. Regarding security, I will bring this up with our senior DBA. I didn't realize that making the SQL service account a local admin was...
July 24, 2023 at 3:18 pm
Thanks to you both! Yes btw, Shared Memory is enabled, as are Named Pipes and TCP/IP.
Another reboot worked this time. But I'll trace for blocking to see what the culprit...
July 12, 2023 at 5:41 pm
Thanks for this very instructive question. I didn't realize that the swap works in UPDATE statements - if that had been the question of the day, I would have gotten...
April 19, 2023 at 1:38 pm
Thanks to everyone for their help. The issue was resolved by another colleague who discovered that there was a custom endpoint set up. Once the permission to that custom connection...
April 4, 2023 at 8:40 pm
Great question, sorry I didn't provide this info earlier.
So far, I can log in locally and remotely using my AD login. The colleague who reported the issue can also log...
April 3, 2023 at 2:09 pm
Hi Andy, Jonathan,
Thanks so much for your help. Sorry, just to clarify - I have not tested the AD login locally. That user doesn't have (i.e., is not allowed to...
April 3, 2023 at 1:44 pm
Viewing 15 posts - 1 through 15 (of 1,171 total)