Any thoughts?

Facing a new problem with my implementation. Previously i have configured with two nodes and after creating the listener nslookup shows associated IP addresses for the listener. But with 3...

I also looked at the transaction logs growing or differential and see how big they were. Is this too simplistic? Obviously that would only show transaction activity, which can be...

Would there be any entry in the logs if this database was previously used, don't have auditing and doesn't look it is used in anywhere.

I don't see any activity against the db. Before taking it offline i wanted to make sure when it was last used or something like that.

Thanks Steve. Just to clarify currently the application is pointing to Alias, this will be side by side upgrade, once the upgrade is done the DNS alias will be upgraded...

My understanding is that database name can stay the same, dns alias would be for the server name right?

Thanks.  I have another question to ensure and outlined a 4-node cluster i am planning to configure. Node 1 - Primary

Node 2 - Secondary (HA) - synchronous, Node 3 -...

Thanks Steve. I have another question and outlined a 4-node cluster i am planning to configure. Node 1 - Primary

Node 2 - Secondary (HA) - synchronous, Node 3 - Secondary...

I was thinking of requesting generic AD account for testing to run the restore Job with minimal rights instead of my own account, since i am part of the Sysadmin...

In an event of disaster. If the fail-over is done to DR site and then DR will become primary, so in that case the backups are needed to be configured...

Frederico, i looked at link and it worked for DBCC. However, when i try for restoring the database from backup file share location and i am using sys.xp_cmdshel and then...

Thanks Sue for confirming from the replication side.What if i have to configure Always on 1 to 1 database ,would setting up between SQL 2016 as primary and SQL 2017...

I understand that it won't be possible to configure Always on from 2 database to 1 database. Yes it could be done with replication. But Primary as sql 2016 and...

Thanks Dan! So once i change the owner of the job to one individual, does that mean he can able to view and execute that particular Job only? However, i...