Forum Replies Created

Viewing 15 posts - 1 through 15 (of 70 total)

  • Reply To: Listener

    Thank you!

  • Reply To: Listener

    That's a good question. Our VPN will work on active DNS entries sadly due to multi subnet it see's multiple DNS entries with active and inactive IP addresses. I understand...

  • Reply To: Replication

    I can able to setup up replication from Standalone On prem SQL Server to SQL MI using Managed instance link. But when the On prem database is already part of...

  • Reply To: Replication

    Can you able to create AG on SQL MI which is PAAS service in Azure.

  • Reply To: SSPI handshake

    I've seen messages like this in connection with password expiration. I think it occurs when someone attempts to connect with a Windows login whose password has expired. Would this be...

  • Reply To: Listener IP

    Server IP address was changed. After setting up the same previous IP it was still showing failed status.

  • Reply To: Access db

    But this will be hosted on production server where there are all other databases get backed up and patching etc. I agree that we should not support a database when...

  • Reply To: Access db

    Planning to host this Access db migrate to SQL Server production. Having their own database would you give full access to that particular db in production? Since it's production do...

  • Reply To: Always on Secondary Database

    When I did the failover to secondary. I had database was recovering on former primary, but it was very slow taking longer. If that is the case then you would...

  • Reply To: Always on Secondary Database

    Would like to test fastest way of recovery rather than waiting for the SQL Server to recover on it's own.

  • Reply To: Always on Secondary Database

    Thanks. It's close but wish something closer that can reproduce in the error logs with  "recover of database is completed x%"

  • Reply To: On what basis do we decide whether to use GDR or CU?

    Can you clarify. There is a confusion around CU, CU-GDR and GDR on what branch of SQL Server you're on. So my understanding is if it's CU-GDR then it will...

  • Reply To: migration

    It is SQL 2017. I agree backup and restore is an option. However, I am looking to replicate the data from on prem to Azure MI continuously. Does Log shipping...

  • Reply To: Server IP change

    On a different note, we are doing firmware upgrade on Always on AG group but this upgrade is pushed all at once to both UAT and Prod. I was hoping...

Viewing 15 posts - 1 through 15 (of 70 total)