Configuration1. Go to our Primary Server (SQL1)
2. Create a Shared Folder "Primary Logs"
Configuration1. Please make sure that the Domain account that is running the SQLAgent has administrative rights in the Shared Folder.
Configuration1. Please make sure that the Domain account that is running the SQLAgent has administrative rights in the Shared Folder.
Configuration1. Connect to our Primary Server (SQL1)
Configuration1. Right click on our EmployeeDB databse
Configuration1. Select the Transaction Log Shipping Page
2. Check the Enable this as a primary database in a log shipping configuration tickbox.
3. Click the Backup Setting button.
Configuration1. Type-in the Network path of our Shared Primary logs folder.
2. Click on the Schedule button.
Configuration
1. Configure the Backup Schedule of the Primary Database.
2. Click Ok button.
Configuration1. Click Ok Button.
Configuration
1. Let's add a secondary server instance.
2. Click Add button.
Configuration
1. Click the Connect button.
Configuration
1. Let's connect to our Secondary Database Server (SQL2).
2. Click Connect button.
Configuration
1. Initialize the Secondary Database.
2. Go to the Copy Files Tab.
Configuration1. Type-in the Destination Folder for copied files.
2. Click the Schedule button.
Configuration
1. Schedule the Copy Job.
2. Click Ok button.
Configuration
1. Go to the Restore Transaction Log Tab.
2. Choose a Database state when restoring a backup.
3. Click the Schedule button.
Configuration
1. Schedule the restore job.
2. Click Ok button.
Configuration
1. Check the Use a monitor server instance tickbox.
2. Click the Settings button.
Configuration
1. Let's connect to our Monitor Server.
2. Click Connect button.
Configuration
1. Click Ok button.
Configuration1. Review the Log Shipping Configuration.
2. Click Close button.
Testing1. Connect to our Primary Database
2. create a Transaction.
Testing1. Connect to our Read-Only Secondary Server.
2. Select the transaction you have created.
No comments:
Post a Comment