The sqllogship application performs a backup, copy, or restore operation and associated clean-up tasks for a log shipping configuration. The operation is performed for a specific database on a specific instance of SQL Server 2005 or a later version.
For the syntax conventions, see Command Prompt Utilities.
We recommend that you use the backup, copy, and restore jobs to perform the backup, copy and restore when possible. To start these jobs from a batch operation or other application, call the sp_start_job stored procedure.
The log shipping history created by sqllogship is interspersed with the history created by log shipping backup, copy, and restore jobs. If you plan to use sqllogship repeatedly to perform backup, copy, or restore operations for a log shipping configuration, consider disabling the corresponding log shipping job or jobs. For more information, see How to: Disable or Enable a Job (SQL Server Management Studio).
The sqllogship application, SqlLogShip.exe, is installed in the x:\Program Files\Microsoft SQL Server\90\Tools\Binn directory.
sqllogship uses Windows Authentication. The Windows Authentication account where the command is run requires Windows directory access and SQL Server permissions. The requirement depends on whether the sqllogship command specifies the -backup, -copy, or -restore option.
Requires read/write access to the backup directory.
Requires the same permissions as the BACKUP statement. For more information, see BACKUP (Transact-SQL).
Requires read access to the backup directory and write access to the copy directory.
Requires the same permissions as the sp_help_log_shipping_secondary_database stored procedure.
Requires read/write access to the copy directory.
Requires the same permissions as the RESTORE statement. For more information, see RESTORE (Transact-SQL).
To find out the paths of the backup and copy directories, you can run the sp_help_log_shipping_secondary_database stored procedure or view the log_shipping_secondary table in msdb. The paths of the backup directory and destination directory are in the backup_source_directory and backup_destination_directory columns, respectively.