2012年3月7日星期三

Disappearing conflicts and snapshot

Hi ng,
we have serious problem,
we administrating one merge replication between Sql 2000 Serwers,
we had about 1000 conflicts in ConflictViewer,
we wanted to resolve this conflicts in monday, but during the weekend new
snapshot was generated and our all conflicts disappeared.
now we have no data from subscriber refered to this conflicts and we don't
know what to do?
we tried to update all records at the subscriber, but this didn't help, all
records was replicated except this 1000 conflicted,
thanks for any help
pozdrawiam
Kuba Guszkiewicz
k.gluszkiewicz@.citysoftware.com.pl
tel. 509-650-351
(22) 869-51-76
(22) 869-51-77
fax (22) 869-51-78
restore the publisher backup (from a day before the snapshot was generated)
on a separate server. You will find them there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kuba Guszkiewicz" <k.gluszkiewicz@.citysoftware.com.pl> wrote in message
news:%23YhmBdtsFHA.2592@.TK2MSFTNGP09.phx.gbl...
> Hi ng,
> we have serious problem,
> we administrating one merge replication between Sql 2000 Serwers,
> we had about 1000 conflicts in ConflictViewer,
> we wanted to resolve this conflicts in monday, but during the weekend new
> snapshot was generated and our all conflicts disappeared.
> now we have no data from subscriber refered to this conflicts and we don't
> know what to do?
> we tried to update all records at the subscriber, but this didn't help,
all
> records was replicated except this 1000 conflicted,
> thanks for any help
> --
> pozdrawiam
> Kuba Guszkiewicz
> k.gluszkiewicz@.citysoftware.com.pl
> tel. 509-650-351
> (22) 869-51-76
> (22) 869-51-77
> fax (22) 869-51-78
>
|||Hilary,
many thanks for your advice,
indeed, we have that backup, but i'm not sure how to restore this on another
database,
could you tell me some more details?
tia
kg
|||Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kuba Guszkiewicz" <k.gluszkiewicz@.citysoftware.com.pl> wrote in message
news:%23K3J21usFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hilary,
> many thanks for your advice,
> indeed, we have that backup, but i'm not sure how to restore this on
another
> database,
> could you tell me some more details?
> tia
> kg
>
|||Create a new database, and restore the backup into this database. Use the
keep_replication switch.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kuba Guszkiewicz" <k.gluszkiewicz@.citysoftware.com.pl> wrote in message
news:%23K3J21usFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hilary,
> many thanks for your advice,
> indeed, we have that backup, but i'm not sure how to restore this on
another
> database,
> could you tell me some more details?
> tia
> kg
>

没有评论:

发表评论