restarting sql server with transactional replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sammy - 29 Nov 2005 14:57 GMT

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

Reply to this Message

Hilary Cotter - 29 Nov 2005 17:15 GMT

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.

Signature

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

> 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
[quoted text clipped - 8 lines]
>
> Sammy

Reply to this Message

Sammy - 30 Nov 2005 09:09 GMT

Thanks Hilary

Sammy

> 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
[quoted text clipped - 12 lines]
> >
> > Sammy

Reply to this Message