> Environment:
> Central SQL 2000 db (with SP3a), employing 3 Merge Publications with
column
> level tracking
> 240 distributed/disconnected subscribers using pull subscriptions running
> MSDE 2000
>
> We're having a high volume of suspect databases appearing. Causes are
varied
> but the majority are torn pages. None are due to running out of disk
space.
> Currently our fix is to drop the database & rebuild it using replication.
> However this is pretty slow. So alternatively, if we took daily backups of
> each subscriber db, would a simple restore make everything work again?
>
> If we take a backup at 1am, the user syncs at 9am and then subsequently
the
> database becomes suspect & we need to restore the backup. Will the
> subscriptions continue to work and will the data that was sync'd at 9am be
> retransmitted down to the subscriber?
>
> Does anyone foresee any other problems?
>
> thanks,
>
> Jonathan
>

"Hilary Cotter" wrote:

> I think you should address your torn pages problem. For instance it could be
> a disk, controller, or a power purity problem.
>
> To address your question. If you restore the backup to the subscriber, the
> publisher will fill in the missing data since 9:00 am.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Jonathan Ainsworth" <JonathanAinsworth@discussions.microsoft.com> wrote in
> message news:55C49FD8-2BBC-406E-9815-0EFAD17268B6@microsoft.com...
> > Environment:
> > Central SQL 2000 db (with SP3a), employing 3 Merge Publications with
> column
> > level tracking
> > 240 distributed/disconnected subscribers using pull subscriptions running
> > MSDE 2000
> >
> > We're having a high volume of suspect databases appearing. Causes are
> varied
> > but the majority are torn pages. None are due to running out of disk
> space.
> > Currently our fix is to drop the database & rebuild it using replication.
> > However this is pretty slow. So alternatively, if we took daily backups of
> > each subscriber db, would a simple restore make everything work again?
> >
> > If we take a backup at 1am, the user syncs at 9am and then subsequently
> the
> > database becomes suspect & we need to restore the backup. Will the
> > subscriptions continue to work and will the data that was sync'd at 9am be
> > retransmitted down to the subscriber?
> >
> > Does anyone foresee any other problems?
> >
> > thanks,
> >
> > Jonathan
> >
>
>