Friday, February 24, 2012

Can i synch databases with logshipping?

I have 2 databases on different location can i sync one database with data
from the other using logshipping by copying the log file from one location
to the other?
There's no network share between the 2 servers.
I know i can do a replication via FTP but thats not really what i want to
do.
What i really want is that the remote location copy updates on a memory
medium which then can be
used to sync the main database.
Any suggestions
Thanks
No, log shipping requires the destination database to be read only. If
you make any changes to this database while you are still applying logs
to it, you will invalidate the log chain.
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
|||I agree and I'd also add that in normal log-shipping it is actually
impossible to make any changes to the stanbdby database as the log is
restored either with norecovery or standby, both of which prevent writes.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment