Hi  Eddie Wuerch,

can we use same listener name on primary and DR in DAG?

if both listener  names are same we dont need to change app config setting to perform dr...

• This reply was modified 3 years, 5 months ago by  dastagiri16.

remove replica also from AG then it will get shrink

Thanks Eddie Wuerch ... i will check and test this....

• This reply was modified 4 years, 4 months ago by  dastagiri16.
• This reply was modified 4 years, 4 months ago by  dastagiri16.
• This reply was modified 4 years, 4 months ago by  dastagiri16.

Thanks for your help..sure definitely i will look forward other options

Thanks both of u in details explanation .. the only concern is to improve performance.

Thanks.. yes, report server is okay.. but here user database and my application is not able to authenticate with db.. login page also failing.let me check once after enabling trace...

Thanks for your inputs...

we will fallow any one of the option.

 is server and db collations should be same right always?  

Thanks,got it

Hi,

Yes, pull subscription  replication and distribution database existing on report server.
We are rebuilding all databases in report server.