Can you send the script? Also, how do you handle all the permissions in DEV and TEST which are different than production. How do you grant them after the refresh....

We are doing DR test. In order to do the DR test i have to break the mirroring instead of failover, that way the databases will be available on both...

How to break the mirroring?

I did configure the distributor for mirror. Still no luck?

I think you may be right. I have tested the scenario with test database.

I did the failover, the replication publisher moves to DR site. However, the changes won't...

Well the front end has some issues with availability group. So we cannot use that at this point. So replication would break when you do the failover right? If yes,...

I am planning to do Database mirroring failover. What do you think i should ensure other than just doing failover. Is anything i would need to worry about before or...

We have seen the issue with creating snapshots on the mirror server. Do you know why this could happen? Does restarting the Endpoints help any?

Thanks! You're awesome.

So how does the mirror will catch up after the restore. How does it push the changes? Do i need to stop the backups on principal after that? Please advise?

What did you find the error? If yes, could you please share the error message and what did you do to fix the problem?

Thanks to everyone!

Thanks! I am not able to find the SQL Server 2017 enterprise evaluation download. All i can see is express edition. Is this something you ever have to install and...

I understand business environments use windows server. However, the one i am talking about is the windows server which will not have GUI and you have to install software's using...

Table A
ID Active_ID
1 1 
2 1
3 1

Table B
ID Active Values
1 1,2,3,4,5 
2 2,3,4,5,6
3 1,6,7,8,6

SO i want to compare Active_ID with...