What are the challenges you face when working across database platforms? Take the survey
Options

Red Gate Should Install On Both Server Primary and Secondary

Rajnish AwasthiRajnish Awasthi Posts: 14
edited September 30, 2008 1:45AM in SQL Backup Previous Versions
Hi,
I am just confuse that should i install red gate software on both server primary and secondary to apply log shipping ?

Rajnish

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Log shipping basically involves backing up the transaction log of a primary database, and restoring the backups to the secondary database.

    Thus, it follows that if you back up the transaction log using SQL Backup, you would also need to use SQL Backup to restore the backup files. You could first convert the SQL Backup-created files to regular native SQL Server backup files, then restore the resulting file(s), but that would involve additional steps.

    SQL Backup is not an application that facilitates log shipping using native SQL Server backup and restore functionality.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Thanks for reply,

    but I found a pdf file where it is mention that sql backup pro should be installed on both server.

    May be it is required because this red gate tool use compress version of backup file which should be uncompressed on secondary server.

    Prerequisites

    To perform log shipping using the SQL Backup Log Shipping wizard:
    •
    You must have at least two SQL Server database engine servers or two database engine instances in your log shipping implementation.
    Note that you cannot ship transaction logs from a SQL Server 2005 database to a SQL Server 2000 database, because of the differences in their structures (but you can ship from a SQL Server 2000 database to a SQL Server 2005 database if you use No Recovery Mode – see Choosing the Log Shipping Mode later in this article).
    •
    SQL Backup Pro must be installed on both of the SQL Servers.
    •
    The database must use the full or bulk-logged recovery model.
    •
    You must have a shared folder to copy the transaction log backups to.
    The SQL Server Agent service account of the primary server must have read/write access either to the shared folder or to the local NTFS folder. The SQL Server Agent account of the standby server must have read and delete access to the shared folder.
    •
    The SQL Server Agent services must be running and configured with network credentials (such as a domain account) if you plan to use a network share as the shared folder.
    You can configure log shipping with SQL Server Agent services stopped, but the process does not run until the agent is started.
  • Options
    peteypetey Posts: 2,358 New member
    If you plan to use the log shipping feature in SQL Backup, you will indeed need to install SQL Backup Pro on both servers.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.