"Sammy" <Sammy@discussions.microsoft.com> wrote in message
news:9352F697-F9A5-4ED5-8C2A-9888A8EC7ABB@microsoft.com...
> Hi I have transactional replication on my server. If I need to restart the
> Agent or Sql Server is there anything I should be aware of or is there a
> set
> way to restart sql server or the agent. If I restart Sql Server while a
> transaction is going on will there be any corruption or will Sql Server
> just
> restart know where it was left in the Tranaction and continue without any
> problems.
>
>
>
>
> Thanks for any answers
>
> Sammy

"Hilary Cotter" wrote:

> Replication will pick up where it left off. Uncommitted transactions will be
> rolled back, committed ones in the tlog will be applied if they are not
> already committed to the database files.
>
> --
> 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
>
> "Sammy" <Sammy@discussions.microsoft.com> wrote in message
> news:9352F697-F9A5-4ED5-8C2A-9888A8EC7ABB@microsoft.com...
> > Hi I have transactional replication on my server. If I need to restart the
> > Agent or Sql Server is there anything I should be aware of or is there a
> > set
> > way to restart sql server or the agent. If I restart Sql Server while a
> > transaction is going on will there be any corruption or will Sql Server
> > just
> > restart know where it was left in the Tranaction and continue without any
> > problems.
> >
> >
> >
> >
> > Thanks for any answers
> >
> > Sammy
>
>