troubleshooting Question

SQL Server 2005 stopped doing replications between different machines/countries

Avatar of tiagorferreira
tiagorferreiraFlag for Portugal asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
5 Comments1 Solution1334 ViewsLast Modified:
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.Replication.NativeSqlConnectionException
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
ASKER CERTIFIED SOLUTION
Ram4020

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros