Using Transaction log to update another database

[mokles]

I am doing some replication setup in test environment. Will it be possible
to use the transaction log from a production server to update the test
server? Any reference to any document will also be appreciated.

I know I have to restore most recent backup from the production server to
the test server. and all the transactions after the backup on the production
server has to be run on the test server.

Thanks for your reply.
-Mokles

[John Bell]

Hi

I think you are looking for log shipping which can be found in books online.
There have also been several articles in SQL Server magazine about writing
your own system to ship logs
http://www.winnetmag.com/Article/Art...231/23231.html

Log shipping may not be what you should be doing to keep a test server up to
date. Periodic restoration of a recent backup may be enough to enable you to
investigate any problems with you live system. If the server is being used
for pre-release testing or regression testing then you certainly will not
required ship logs.
John

"mokles" <mo****@rogers.com> wrote in message
news:Xe******************@news01.bloor.is.net.cabl e.rogers.com...

I am doing some replication setup in test environment. Will it be possible
to use the transaction log from a production server to update the test
server? Any reference to any document will also be appreciated.

I know I have to restore most recent backup from the production server to
the test server. and all the transactions after the backup on the production server has to be run on the test server.

Thanks for your reply.
-Mokles