We need to push all the changes across network to a secondary, reporting
server, on a timely manner. We were using replication in SQL200, but it
takes a lot server resources. Any new feathers in SQL2005?
There are a lot of new features in SQL 2005. Transactional replication will
place fewer locks on the publisher by default during snapshot generation.
You could also look at database snapshots or log shipping for this.
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
"awan" <awan@.discussions.microsoft.com> wrote in message
news:5D8A9D21-2AF4-4EB7-AAFA-603FCDA399FA@.microsoft.com...
> We need to push all the changes across network to a secondary, reporting
> server, on a timely manner. We were using replication in SQL200, but it
> takes a lot server resources. Any new feathers in SQL2005?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment