What is Log Shipping?

Posted Date: 17 May 2008 Resource Type: Definitions Category: General

Posted By: Ashutosh Kumar Member Level: Gold
Rating:

Points: 10

In Microsoft® SQL Server™ 2000 Enterprise Edition, you can use log shipping to feed transaction logs from one database to another on a constant basis. Continually backing up the transaction logs from a source database and then copying and restoring the logs to a destination database keeps the destination database synchronized with the source database. This allows you to have a backup server and also provides a way to offload query processing from the main computer (the source server) to read-only destination servers.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: What are EBooks?
	Previous Resource: What are master, msdb, tempdb databases in Sql Server?
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

Read TATA Nano reviews.
dotNet Slackers BizTalk Adaptors Web Design Scripts
Are you waiting for engineering entrance result? Watch here for engineering entrance results.
it support