sql server replication: Backup & Restore a publisher database -- sql server replication

Backup & Restore a publisher database

Marco
5/7/2004 1:01:07 AM

sql server replication:

Hello

After restoring a publisher database, starting a merge-agent results in the error

"The initial snapshot for publication 'XXXX' is not yet available.

I don't understand this, because before I performed the backup, the initial snapshot was generated.

When I regenerate the snapshot, everything works fine. But I want to restore the database without regenerating the snapshot. Does someone has a solution

thanks in advance, Marc

Re: Backup & Restore a publisher database

Marco
5/7/2004 6:11:03 AM

just a few minutes. Nothing was changed in that time

I hope you know a solution

Marc

----- Hilary Cotter wrote: ----

how "old" was the backup you restored
"Marco" <anonymous@discussions.microsoft.com> wrote in messag
news:4D80EBDD-10B4-4F38-B03F-EEA7F071BEA0@microsoft.com..
[quoted text, click to view]
restore the database without regenerating the snapshot. Does someone has
solution
[quoted text, click to view]

Re: Backup & Restore a publisher database

Hilary Cotter
5/7/2004 6:49:53 AM

how "old" was the backup you restored?
[quoted text, click to view]
restore the database without regenerating the snapshot. Does someone has a
solution ?
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.