Viewing 15 posts - 16 through 30 (of 267 total)
Sorry, I am not sure of your questions:
So the plan is to test which would be the faster in terms of failover?
Are you asking us if this is a...
November 20, 2020 at 11:53 am
I don't know the cause of this but maybe the following will help work out the issse:
Can you run the following?:
select * from sys.dm_hadr_availability_replica_states
This should show the...
November 18, 2020 at 11:18 am
silly question.. but how do I give you the DDL?
There is some guidance here https://qa.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
November 16, 2020 at 4:34 pm
Please help me to form a SQL query to find out how we can get missing month flag value.
Did you mean how to set the 'month skip' column...
October 24, 2020 at 4:20 pm
Thank you for your help. That did improve the plan.
I would also be interested to know if my reading of the original plan was correct.
October 23, 2020 at 10:30 am
Thanks for your help.
I thought I added a comment both times but possibly not. Sorry, probably user error on my part.
October 19, 2020 at 6:18 pm
I think it says no action is required because it can fix itself. However losing quorum is likely to be a potential problem.
What items are part of the Windows Server...
October 11, 2020 at 5:35 pm
Check the database mail log.
is your company allowing you to send emails to external addresses?
In addition to this; your email server might restrict or allow emails to specific domains...
October 8, 2020 at 8:03 pm
Sorry I am not sure what you are asking. The case statement you show has two options - 'replicated' or 'not replicated' so I don't understand when you would like...
October 2, 2020 at 5:49 pm
My experience is with on premise setups so my comments focus on that.
I think you can create an Availability Group with just one Windows Server however it will limit what...
September 29, 2020 at 2:07 pm
Firstly I'm only a Junior/mid level DBA so I could be wrong with this.
Secondly I appreciate it's a copy-only backup so perhaps not part of your normal backup strategy.
Your questions...
September 24, 2020 at 8:14 pm
Create your availability group, configure the listener, add databases. Add as many databases as you need
Application connects using listener name, think of that as your new server name. Connection...
September 11, 2020 at 11:10 am
Sorry if I sounded like that.
You didn't at all. I understood what you meant. My "I don't intend to come across as ..." was entirely paranoia about my posts...
September 10, 2020 at 2:42 pm
Edit: BrainDonor and I replied at the same time.
My original reply was only a reply to Grant's reply.
---Original reply---
Thank you for all your advice. It's really helpful
As you said certificates...
September 10, 2020 at 1:55 pm
Viewing 15 posts - 16 through 30 (of 267 total)