Viewing 15 posts - 1 through 15 (of 36 total)
Thanks. How about the database name standards?
October 8, 2021 at 9:24 pm
The wait stats I am seeing is LCK_M_U, WRITELOG and LCK_M_S are they normal behavior or something to be looked into it?
September 14, 2021 at 4:37 pm
So that will end up with changing the server IP address? It is our current production server? Would changing the IP will have any impact?
September 2, 2021 at 9:20 pm
That scope is full. Unable to move or decomm any other. I would need to come up with another plan.
Would changing the IP address of the node is the only...
September 2, 2021 at 7:32 pm
Thank you sir!
September 1, 2021 at 5:34 pm
I was thinking of failover test to ensure the replication is working when primary becomes secondary? Any other thoughts?
August 30, 2021 at 4:30 pm
Thanks! During the seeding process if I use the option of backups then I would not be doing log backup until the seeding is finished right? Or then I have...
August 25, 2021 at 3:00 pm
The log I provided is from windows event viewer. I know when it started, but I am trying to find who started?
August 11, 2021 at 3:30 pm
Connecting to server works but when connecting using listener it times out. Any thoughts? Thanks in Advance!
August 9, 2021 at 11:18 pm
Using listener there are timeouts from application. Does increasing the session timeout is advisable from availability group properties?
August 4, 2021 at 11:32 pm
What's your thoughts on cross database ownership chaining? I have tested and it works. Is there any security risk?
July 27, 2021 at 10:27 pm
I am a bit confused on the permissions required to execute stored procedure. For example, if you have 2 tables and a stored procedure which reads data from Table1 and...
July 22, 2021 at 5:10 pm
Thanks a lot guys.
July 6, 2021 at 8:39 pm
Thanks! Do I need to mention the reason or did by accident would be suffice along with explanation like you said I will research and prevent that from happening again.
July 6, 2021 at 4:13 pm
I have setup the availability group as below.
Primary Replica - Full, Diff and Log backups & Maintenance Jobs etc.
Secondary Replica 1(Synchronous commit) - For HA and Automatic Failover
Secondary Replica 2...
June 16, 2021 at 3:05 pm