Restore Options

Hi NG,
I use with backup', 'true' on Distribution and PublisherDB.
If I make a RESTORE on the SAME SERVER,
is it necessary to set KEEP_REPLICATION?
BOL says, that KEEP_REPLICATION only must be set
if the restore goes to another server.
And why should handling the LOG?
Thanks Thomas
correction:
I use
sync with backup = true
on Distribution and PublisherDB.
|||If you want to restore the publication metadata yes.
BOL is more than a little confused on this issue.
I don't understand you question about the log. You don't use the
Keep_replication switch when restoring the log.
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
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:4218f32a.332552781@.news.t-online.de...
> Hi NG,
> I use with backup', 'true' on Distribution and PublisherDB.
> If I make a RESTORE on the SAME SERVER,
> is it necessary to set KEEP_REPLICATION?
> BOL says, that KEEP_REPLICATION only must be set
> if the restore goes to another server.
> And why should handling the LOG?
> Thanks Thomas
|||Hi Hilary
On Fri, 18 Feb 2005 13:39:25 -0500, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>If you want to restore the publication metadata yes.
>
OK

>BOL is more than a little confused on this issue.
>I don't understand you question about the log. You don't use the
>Keep_replication switch when restoring the log.
I thought the option Keep_Replication
must be applied to data and to log.
Thomas
|||online the database backup, you get an error message when using it with the
log. I opened up a support incident with Microsoft on this requesting
clarification to confirm my observation.
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
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:421f4ef2.421584796@.news.t-online.de...
> Hi Hilary
> On Fri, 18 Feb 2005 13:39:25 -0500, "Hilary Cotter"
> <hilary.cotter@.gmail.com> wrote:
>
> OK
>
> I thought the option Keep_Replication
> must be applied to data and to log.
> Thomas