How would I setup Log Shipping on 5.x?
Step by step directions are located on our F1 on-line help. Just search for Create Log Shipping Plans
Create Log Shipping Plans
The Create LiteSpeed Log Shipping Plan wizard helps you create a log shipping plan. You will select a publisher database and one or more subscriber databases.
Notes:
- You should review log shipping requirements before creating a plan.
- Performing a transaction log backup on the publisher will break the log shipping plan.
- This topic only covers unfamiliar information. It does not include all step and field descriptions.
To create a log shipping plan with the wizard
1. Select the Log Shipping pane (CTRL+D+2).
2. Right-click the server instance and select Tasks | Create New Log Shipping Plan Wizard.
3. Review the following additional information about the Backup Options page:
a. - UNC path to share folder where backup files are available for subscribers
Enter the network path or click to navigate to it. You should always complete this field.
Note: UNC paths have the following format: \servernameshareddrive.
b. - Specify local path
Specify the local path if your SQL Server Service Agent is running on a local system account.
If you enter a local path, the stored procedures and jobs on publisher will use the local path instead of the UNC path.
Otherwise, this field is not required.
c. - Perform full backup and then restore to initialize subscriber(s)
Select to have LiteSpeed perform a full backup and restore it on the subscribers when creating the plan.
If you do not select this checkbox, you must perform a full backup of the publisher and restore it on the subscribers before finishing the wizard.
Note: Log shipping will not work unless you perform a full backup when setting up the plan.
You can further customize the plan by modifying the advanced options. Refer to Addtional Information for explanation on it.
4. Add one or more subscribers on the Subscribers page.
Note: In the Log Shipping Subscriber window there are two options for the Recovery mode field.
Loading prevents users from querying the database. Read-only allows users to query the database.
If you select Read-only, you should select Disconnect users when restoring backup to ensure that LiteSpeed can perform the restore;
otherwise, you will have to manually disconnect them.
5. Complete the wizard.
Tip: To edit a log shipping plan (for example, to add a new Subscriber), right-click the plan and select Edit Log Shipping Plan Wizard...
Compression level
- Select 0 for no compression or 1-11 to compress the file.
Note: Higher compression levels result in smaller backup files, but they also take longer to complete.
For assistance determining the best compression ratio, see Test Optimal Backup Settings.
- Encrypt backup
Select this checkbox to encrypt the backup. Then, select the encryption level and enter the encryption password.
Set the following parameters manually:
Throttle
- Enter the maximum percentage of CPU that LiteSpeed can use for the process.
Priority
- Select the priority of the backup over other transactions or processes running on the same server.
Buffer count
- Enter the number of SQL Server buffers available for a LiteSpeed operation.
Max transfer size
- Enter the maximum backup file size in bytes.
Processor affinity
- Click the box to select which processors LiteSpeed can use.
Number of threads
- Enter the number of threads used for the backup. The default is n-1 threads, where n is the number of processors.
Logging level
- Select one of the following options:
a. None - LiteSpeed does not log backup activity.
b. Errors only - LiteSpeed logs errors during the backup process.
c. Verbose - LiteSpeed logs all backup activity. Verbose logging can cause large log files.
d. Verbose on failure - LiteSpeed creates verbose logs and only saves them if the backup fails. If it succeeds, LiteSpeed does not save the log.
Note: Selecting Verbose on failure can significantly reduce the troubleshooting process if the activity fails.
Note: LiteSpeed defaults typically result in the best performance. You should only modify advanced options after careful planning and testing.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center