Forum Replies Created

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

  • Reply To: Replication

    FYI..I just tested it in the test environment. So pausing the db mirroring is also pause the replication sync since both based on transaction log. So the assumption is correct....

  • Reply To: Faster Integrity check

    I did run some tests. On SQL 2014 it is taking approx 8 - 10 hrs and on SQL 2017 it is taking less than 2 hrs. I can't believe...

  • Reply To: Sql to oracle replication

    I started working on CDC from sql to oracle(destination). However, it might take some time for me to get access to oracle. So I thought enable the CDC on source(SQL)...

  • Reply To: Backup server

    Thanks Brian! After further discussions with storage team, found that our backup server is virtual storage machine on a clustered storage system. The storage volumes currently used by backup server...

  • Reply To: Backup server

    Just to clarify about the maintenance. Let me recap. The maintenance is performed on the backup server from the storage team, so backup volumes would be unavailable during the maintenance...

  • Reply To: Backup server

    Thanks brian. I like the idea of requesting to move the backup disk off the backup server while the maintenance is performed. Can you give more details on this?

  • Reply To: Backup server

    Storage guys found the window where there is no activity on the backup server. Would you agree that would be the best window?

  • Reply To: Backup server

    homebrew01 wrote:

    Could you set up a local Maint Plan to take Trans Log backup during the maintenance window ?

    We have multiple servers. So you suggesting to change all backups(You mean...

  • Reply To: implement Appdynamics database monitoring for SQL server

    I understand that App D, it will be used for application monitoring. If you have already database monitoring tool configured. Would App D interfere with already configured monitoring tool for...

  • Reply To: Backup server

    Thanks I agree with all you. What if you have lots of servers across the board? It would be hard to find the good maintenance window right? So there would...

  • Reply To: Sql to oracle replication

    Any thoughts on Qlik or Qlik connector for replication from sql to oracle. It doesn't seems to work on prem is that for a cloud? Do you agree?

  • Reply To: SQL Server rename

    Sorry I am confused. The aliases is pointed to current prod server.So my understanding is the aliases cannot be pointed to new prod server until the go live. So the...

  • Reply To: Replication and always on

    Thank you! Trying to clarify about normal availability group, does it mean AG without Windows server fail over cluster? Please correct me if I am wrong? Do you see any...

  • Reply To: SQL Server rename

    Any thoughts?

  • Reply To: Replication and always on

    Thanks. I agree with you. All servers are enterprise edition.

    Server A - Primary

    Server B - Secondary (for reporting) - asynchronous

    Server C - Secondary (DR) - asynchronous

    Databases:

    Database A - Basic availabililty...

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