troubleshooting Question
SQL Server 2005 stopped doing replications between different machines/countries
asked on
Hello
We had a stored replication in a machine in POLAND in which it does replications to SPAIN
However, this is happening:
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074)
This is in the replication monitor.
In the SQL log:
Message
Replication-Replication Snapshot Subsystem: agent PL01\SQLPL-N60-POLAND-1 scheduled for retry. The replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replic
Exception Message: There is not enough space on the disk.
Message Code: 0
There is 970mb in the SQL DATA disk - will be handled by me.
The rest, SQL it self is out of my control as i have no expertise in this field, so, any help is good help
thanks
Tiago
We had a stored replication in a machine in POLAND in which it does replications to SPAIN
However, this is happening:
The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. (Source: MSSQLServer, Error number: 21074)
This is in the replication monitor.
In the SQL log:
Message
Replication-Replication Snapshot Subsystem: agent PL01\SQLPL-N60-POLAND-1 scheduled for retry. The replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replic
Exception Message: There is not enough space on the disk.
Message Code: 0
There is 970mb in the SQL DATA disk - will be handled by me.
The rest, SQL it self is out of my control as i have no expertise in this field, so, any help is good help
thanks
Tiago
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.