Sunday, May 2, 2010

Configuration Of Transaction Log shipping In SQL Server 2005 Step By Step

 Here is the Steps For Transaction Log-shipping configuration step by step

Step 1. First we need to create two folders in separate drives For Example D:\Primary_Logshipped_Database and E:\Copy_Logshipped_Database

Step 2. Give Network Share and Read/Write permissions to both of the folders.

Step 3. Network Path of Primary_Logshipped_Database is \\computername\Primary_Logshipped_Database

Step 4. After that we need to take full and translog backup of source/required database and restore it in to destination database with Stand By mode.

Step 5. After doing so, In Primary server database, right click Taks àShip Transaction Logs

Step 6. After Enabling this as primary database in a Logshipping configuration-Go to Transaction Logs-Backup Settings

Step 7. Here it shows : Network Path to Back up folder (Ex: \\primaryserver\backup) here we need to keep as follows \\Computer Name\Primary_Logshipped_Database and then

Step 8. If back Up Folder is located in Primary server, Type a local path to the folder (Ex:C:\Backup);

Step 9. D:\Primary_Logshipped_Database

Step 10. After that, Schedule the Backup Job for 3 minutes in our configuration

Step 11. and then need to click on Secondary Databases -Secondary server Instances and databases in that click on ADD

Step 12. after that Secondary Databases settings window will open

Step 13. In that window, Conect to Secondary server instance and Secondary Database

Step 14. Click on 'COPY FILES' page-In that page it shows ;Destination Folder for copied files : (This folder is usually located on secondary server) we need to keep 'E:\Copy_Logshipped_Database' path here

Step 15. after doing so schedule the copy job for 3 minutes

Step 16. Now click on restore transaction log page

Step 17. In that click on Stand By mode and check disconnect users when restoring backups

Step 18. After doing so, schedule the restore job for 5 minutes everyday in our configuration

Step 19. and then go to monitor server instance and select secondary server instance is the monitor server instance

Step 20. After configuration of Logshipping, Manually we need to run Copy job in Primary Server-Sql Server Agent-Jobs-Backup Job

Step 21. and we need to run Copy and Restore jobs in Secondary Server-Sql Server Agent-Jobs

Step 22. After your configuration please update the database in primary server and wait for 5 minutes and check in secondary server database whether that update is successfully updated or not.

Step 23. After doing so, Right click on Secondary Server Instance-Click on Reports-Standard Reports-Transaction Logshipping Status

Step 24. In that we can see when is the last backup and restored backup and all things about Logshipping
About Log Shipping, Log Shipping Administration, An Overview of Log Shipping in SQL Server 2005, An Overview of Log Shipping in SQL Server 2008 r2, An Overview of Log Shipping in SQL Server 2012, How to Perform SQL Server Log Shipping, Log Shipping vs Replication, Log shipping MS SQLServer 2008, SQL Server 2000 Log shipping, SQL Server Log Shipping, How to Perform SQL Server Log Shipping, SQL Server Log Shipping Tutorial, sql server log shipping vs replication, sql server log shipping vs mirroring, sql server log shipping interview questions, sql server log shipping port, sql server log shipping firewall ports, sql server log shipping multiple databases, log shipping issues, log shipping errors, Scheduling Sub-Minute Log Shipping in SQL Server 2008, Monitor Log Shipping, View the Log Shipping Report, SQL Server Log Shipping For Large Databases, Configure Log Shipping, Fail Over to a Log Shipping Secondary, Remove Log Shipping, Setting Up Log Shipping, SQL Server Log Shipping to a Different Domain or Workgroup, Step By Step SQL Server Log Shipping,


It is working fine for me. thanks

Post a Comment