What is the comparison of server sizing in terms of RAM/CPU/storage type et between the access and SQL Server. Trying running the query directly on the SQL Server and...

Firstly, your failover cluster failed. Research with your windows Administrator the cause for failure. Your HA needs to happen automatically without any human intervention (no waiting for even emails 😉

As...

Assuming its not a complicated database with any kind of encryption

1. Back up the database. Use native or third party compression tool

2. Transmit and apply the back up , any...

Try sp_recompile the stored procedure with SET FMTONLY right after the index maintenance job.

You can try Control-M

VEEAM provides backup at the VM or Virtual Server Level. While log shipping is at the SQL Server or application level. If you do not want to rely on...

In method (1) side by side , are you planning to have different cluster names?. I would assume to end the migration ,you still need to rename the cluster and...

I was recently asked to provide questions to be asked for a production DBA. There are no good or bad answers, the person must have encountered most of the...