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

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