hi all,
We currently encounter a big trouble:
We have set up a model of synchronization from PDA to SQL Server
succesfully. Everything is OK until SQL Server database met a trouble
and needed to restore database. We restored a rather old database (1
week ago) and then so many erros appeared. Database that is in PDA
contains much newer data than on SQL Server. When we synchorize, it
appeared error 28549: "The row update or insert cannot be reapplied due
to an integrity violation".
I would like to ask whether there is a standard process for Merge
Replication in case of restoring old database ?
FYI: SQL Server 2K with SP3.
Very appreciated for any help.
KNC
This will work if the retention period of the publication is longer than the
age of the backup.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"KNC" <khanh@.glassegg.com> wrote in message
news:1102943950.567639.151310@.z14g2000cwz.googlegr oups.com...
> hi all,
> We currently encounter a big trouble:
> We have set up a model of synchronization from PDA to SQL Server
> succesfully. Everything is OK until SQL Server database met a trouble
> and needed to restore database. We restored a rather old database (1
> week ago) and then so many erros appeared. Database that is in PDA
> contains much newer data than on SQL Server. When we synchorize, it
> appeared error 28549: "The row update or insert cannot be reapplied due
> to an integrity violation".
> I would like to ask whether there is a standard process for Merge
> Replication in case of restoring old database ?
> FYI: SQL Server 2K with SP3.
> Very appreciated for any help.
> KNC
>
|||hi Hilary,
You seems to misunderstand me, of course it still works. But it will
have trouble in following scenario:
- day 6, set up Merge Replication on SQL Server
- day 8, back up SQL Server database
- day 10, there is 1 new record 001 which is inserted into SQL
Server. Then it was synchronized with PDA, so PDA also contains this
new record 001.
- day 12, SQL Server database is corrupted, we restored from day 8.
Then record 001 is also inserted after database restored. When
synchronizing with PDA, it is conflicted with error 28549.
I would like to ask what is the standard process for Merge in case of
SQL server database is often restored.
Thanks much,
Khanh
Hilary Cotter wrote:
> This will work if the retention period of the publication is longer
than the[vbcol=seagreen]
> age of the backup.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "KNC" <khanh@.glassegg.com> wrote in message
> news:1102943950.567639.151310@.z14g2000cwz.googlegr oups.com...
trouble[vbcol=seagreen]
(1[vbcol=seagreen]
due[vbcol=seagreen]
Showing posts with label restore. Show all posts
Showing posts with label restore. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
merge replication restore backup
Georg,
please can you give a bit more info. You want to copy
database 1 to database 2 - on the same server? is
database 2 to be used for reporting? is database 2 to be
a publisher or a subscriber? etc.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
ok i have 8databases puslished on the same machine.
on a second machine i've got 8 subscribers.
no database is used for reporting (?).
now i wanna copy the information from the replicated pair (db1publisher &
db1subscriber) to the second pair (db2publisher - db2subscriber).
you can imagine now, what i wanna do?
"Paul Ibison" wrote:
> Georg,
> please can you give a bit more info. You want to copy
> database 1 to database 2 - on the same server? is
> database 2 to be used for reporting? is database 2 to be
> a publisher or a subscriber? etc.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||The replication details won't transfer without a lot of hacking system
tables. The only viable way is to back up the databases and restore them on
the alternative servers. You can script out the original replication
settings, find and replace the servernames and logins then run the script on
the new servers. After that, you'll need to reinitialize.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
please can you give a bit more info. You want to copy
database 1 to database 2 - on the same server? is
database 2 to be used for reporting? is database 2 to be
a publisher or a subscriber? etc.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
ok i have 8databases puslished on the same machine.
on a second machine i've got 8 subscribers.
no database is used for reporting (?).
now i wanna copy the information from the replicated pair (db1publisher &
db1subscriber) to the second pair (db2publisher - db2subscriber).
you can imagine now, what i wanna do?
"Paul Ibison" wrote:
> Georg,
> please can you give a bit more info. You want to copy
> database 1 to database 2 - on the same server? is
> database 2 to be used for reporting? is database 2 to be
> a publisher or a subscriber? etc.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||The replication details won't transfer without a lot of hacking system
tables. The only viable way is to back up the databases and restore them on
the alternative servers. You can script out the original replication
settings, find and replace the servernames and logins then run the script on
the new servers. After that, you'll need to reinitialize.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Labels:
backup,
bit,
copydatabase,
database,
georg,
isdatabase,
merge,
microsoft,
mysql,
oracle,
replication,
reporting,
restore,
server,
sql
Monday, February 20, 2012
Merge replication after a restore publisher
Merge replication works fine, but if I restore publisher database on SQL
Server 2000,
and I have some records in SQL Server CE database was already merged (after
last backup),
when I synchronize, these records exists on SQL Server CE, but they are lost
on
SQL Server 2000.
I have to put these records on SQL Server 2000, but how can I compare
records that are
both on SQL Server 2000 and SQL Server CE ?
Thanks.
You can update these records in the SQL CE database again, and they should
replicate to back to the publisher the next time you run the activeX
program.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"El Ricoun" <elricoun@.yahoo.fr> wrote in message
news:4207ca97$0$6615$8fcfb975@.news.wanadoo.fr...
> Merge replication works fine, but if I restore publisher database on SQL
> Server 2000,
> and I have some records in SQL Server CE database was already merged
(after
> last backup),
> when I synchronize, these records exists on SQL Server CE, but they are
lost
> on
> SQL Server 2000.
> I have to put these records on SQL Server 2000, but how can I compare
> records that are
> both on SQL Server 2000 and SQL Server CE ?
> Thanks.
>
|||Ok, thanks, it works fine, but I have to update all records of all tables
on SQL Server CE. Is it possible to use s_Generation column to know
which record that I have to update ?
Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
news:egF1ekZDFHA.936@.TK2MSFTNGP12.phx.gbl...
> You can update these records in the SQL CE database again, and they should
> replicate to back to the publisher the next time you run the activeX
> program.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Now available on Amazon.com
>
http://www.amazon.com/gp/product/off...?condition=all
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "El Ricoun" <elricoun@.yahoo.fr> wrote in message
> news:4207ca97$0$6615$8fcfb975@.news.wanadoo.fr...
> (after
> lost
>
Server 2000,
and I have some records in SQL Server CE database was already merged (after
last backup),
when I synchronize, these records exists on SQL Server CE, but they are lost
on
SQL Server 2000.
I have to put these records on SQL Server 2000, but how can I compare
records that are
both on SQL Server 2000 and SQL Server CE ?
Thanks.
You can update these records in the SQL CE database again, and they should
replicate to back to the publisher the next time you run the activeX
program.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"El Ricoun" <elricoun@.yahoo.fr> wrote in message
news:4207ca97$0$6615$8fcfb975@.news.wanadoo.fr...
> Merge replication works fine, but if I restore publisher database on SQL
> Server 2000,
> and I have some records in SQL Server CE database was already merged
(after
> last backup),
> when I synchronize, these records exists on SQL Server CE, but they are
lost
> on
> SQL Server 2000.
> I have to put these records on SQL Server 2000, but how can I compare
> records that are
> both on SQL Server 2000 and SQL Server CE ?
> Thanks.
>
|||Ok, thanks, it works fine, but I have to update all records of all tables
on SQL Server CE. Is it possible to use s_Generation column to know
which record that I have to update ?
Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
news:egF1ekZDFHA.936@.TK2MSFTNGP12.phx.gbl...
> You can update these records in the SQL CE database again, and they should
> replicate to back to the publisher the next time you run the activeX
> program.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Now available on Amazon.com
>
http://www.amazon.com/gp/product/off...?condition=all
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "El Ricoun" <elricoun@.yahoo.fr> wrote in message
> news:4207ca97$0$6615$8fcfb975@.news.wanadoo.fr...
> (after
> lost
>
Subscribe to:
Posts (Atom)