Try my app Expense Manager @ google play and amazon store.

Tuesday, July 10, 2012

Log Shipping in Microsoft SQL Server

Log shipping in Microsoft SQL Server is process used to automatically taking backup of the database and transaction files from one Microsoft SQL Server and then restoring them on a backup server

Log shipping keeps the two Microsoft SQL Server instances in sync with each other. If production server fails, then users simply need to be pointed to the backup server

Log shipping process consists of following three steps :
  1. Backup transaction logs of the Production server.
  2. Copy these logs on the backup server.
  3. Restore the log on backup server.

No comments:

Post a Comment

Follow by Email

Google+ Badge