Hi,

How many tables you are truncating, like if you ave five table very large then export the data than delete from table subscribe it then import...

Hi Perry,

After executing the query i am getting below details...

1. PRIMARY SERVER :-

Mirroring655362652TCP4DATABASE_MIRRORING0STARTED01PARTNER13NEGOTIATE01RC4

2. Witness Server :-

Mirroring6553612TCP4DATABASE_MIRRORING0STARTED03ALL13NEGOTIATE01RC4

Hi,

Yes, if you replicate table's that particular tables will update.

In replication :- If you insert the data in particular replicated table automatically change in subscriber also....

If you...

Hi Perry,

I am getting same error...

Thanks & Regards

Satish Saidapur

Hi,

I was faced same issue long back, restart the services than immediately execute that query. It will work...

Thanks & regards

Satish Saidapur

Hi,

I want to say one thing i am able to configure mirroring without witness but not able to configure witness.

Assume :- 1 is Primary, 2 is...

Hi,

All updates from PRIMARY instance......

Thanks & Regards

Satish

Hi

Point 1 & 2 is not an issue..

3):I am able to do telnet 5022 but “telnet SQLServerName 5023? not happening

4): Already firewall is turned off.

5): Mirroring655362642TCP4 ...

Hi,

I tried both T-SQL & GUI.....

Yes, I have....

Hi,

This is resolved....

Problem is Servers are not registered in DNS...

Hi,

I tried both....same error...

ERROR :-

Cannot connect to MPBABTPJSDB01

ADDITIONAL INFORMATION:-

An error has occured while estalishing a connection to the server. When connecting to SQL Server 2005,...

Hi,

I tried through port, it's not working....

I have only single instance (Default)...

Hi,

VIA is already disable in my SQL Server, they also i am not able to connecting.

My main issue is i am able to connect through...