QA is requesting for permission for write access on UAT server. I agree that UAT is a testing area and executing procs could be considered part of that testing. But...

Currently I have alias pointing to our current server. However, I am planing to use the same alias name after the upgrade. So the question is how does the testing...

When I change the DB to read only mode. Using the application i get sign on failed. Any idea?

Thanks guys!

Thanks! Since no one has sa and db_owner access other than me.  So I will change the db to read only mode first. Then change the connection string. Would that...

Thank you sir! My understanding is CDC falls under asynchronous process and will not impact the current transactions Vs trigger which falls as synchronous process. Since CDC uses log reader...

Thanks! So I have to setup at server level right? Would there be any impact to other users after setup to kerberos who would be connecting using Windows or any...

Thanks! I can't take it offline. Since users want database to be view only mode for a while. So change the db to ready only mode or rename and ensure...

Thank you sir

Thanks!So now I am trying to build the restore Job with minimum rights?Before restore trying to take db in single user in case any open connections.

ALTER DATABASE DB name SET...

Thanks Brian and Sue! Linked server is created using the security context. I am trying to grant select access to the account which can be used as part of the...

If the secondary replica is asynchronous mode. Would you still do backups on secondary replica to offload the performance? Would there be any issues or concerns on backing on secondary...

Thanks Gale. I agree with you giving the least minimum access. But now they claim that they have to fix data related issue within 6 hrs and sometimes the data...

Thanks! That's what I thought but I wanted to make sure if i'ts not any different. Would CDC method works better for Very large database(2TB)?  Does Informatica handles better Vs...

Why would you use CDC instead of ETL option? Is there any benefits over ETL?