Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

subscription(s) have been marked inactive and must be reinitialized

Status
Not open for further replies.
kongyu

kongyu

MIS
Apr 22, 2002
10
0
0
MY
Hi.
I have found one of the common problem that from my transactional replication, it always give this problem.

Error Message : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.

Error Detail : The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.
(Source: ENG_SISBFP (Data source); Error number: 21074)

How can i change the transaction time to be infinity?
Thank you.
Regards,
kongyu
 
Status
Not open for further replies.

Similar threads

Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
59
Virendra Yaduvanshi
Virendra Yaduvanshi
ahmedsa2018
  • Locked
  • Question
Part Id 3900 take wrong technology id as 7 and it must Be 2 because Feature Name and Value Exist?
Replies
4
Views
79
mikrom
mikrom
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
134
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
121
Andrzejek
Andrzejek
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
186
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top