Posts

Showing posts from November, 2012

Database Experts:Log Shipping for SQL Server 2005 disaster recovery solution

Image
    SQL Server 2005 Log Shipping For Disaster Recovery.  Read this for more information about database log shipping for disaster recovery. http://msdn.microsoft.com/en-us/library/ms187103%28v=sql.90%29.aspx There are three SQL Server instance for Log shipping operation. 1.Primary Server-Source database which logs transfer to multiple secondary server. 2.Secondary Server.Destination server for log shipping where logs apply for recovery. 3.Monitor Server :Monitor Log shipping on this server. **Note:There is one shared drive where transaction logs backup moved to secondary server. Follow this steps for configuring log shipping. 1.Create Shared Drive. This share drive can be accessible by both servers. 2.Create Shared folder to copy transaction logs on secondary server. Give Full Permission to SQL Server Service Account. Here this folder is Shared in Secondary Server. 3.Go to Primary Server for Log Shipping Configuration. Right Click on Database wh