replication stopped - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

replication stopped

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-21 : 12:57:51

Dear All,
i've created replication long back and that is working fine till 3:30 pm today. suddenly two databases are not synchronixing and rest of 3 are working fine(totally 5 databases in transactional replication).
i'm getting the below error while trying to see the synchronization status..
to synchronize and monitor,a connection must established to the publisher
there are no errors in the replication monitor. but it is saying that there are no initial snapshots to replicate the transactions
please help me...

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-21 : 13:35:10

Did somebody delete snapshot folder? Check your shared folder for snapshot? Also check job history for replications.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-21 : 13:38:22

for the same shared folder other databases are working.....

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-21 : 13:48:27

Post the full error.How come you rest of Publication work fine if you have connection issue?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-21 : 13:49:59

Also are subscriber same for 2 databases as other one?

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-21 : 14:24:05

sorry for making the confusion.

actually there are five databases in replication. three are push subscription and working fine. two are pull subscription and failed now. the error i'm getting is the the initial snapshot for publication is not yet avialable'.

for a small database i've generated the snapshot again and that is working fine. but the problem is regarding the big database. why this problem came dont know exactly. please help me here

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-21 : 14:53:29

ok sodeep finally i've decided to delete the subscription and i'l create the new snapshot.
just right click and delete?(subscription) or i need to drop the subscriber database and create a new database, and need to initialize with the latest snapshot?

i mean can i take a fresh snapshot and put it on the existing subscriber database?

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-21 : 14:59:58

Donot generate snapshot for Huge databases. It will lock tables. It will take some time .

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-08-22 : 02:18:46

i've created the latest snapshot, taken sometime...but replication is fine now.

now the problem is performance...previously 15 sec query now taking 20 min. please let mek now how can i resolve this?

even alt+f1 is taking so much time for a table.

Arnav
Even you learn 1%, Learn it with 100% confidence.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources