SQL Server Performance

Server 2000 Log Shipping setup

Discussion in 'SQL Server Log Shipping' started by walterjo, Apr 9, 2006.

  1. walterjo New Member

    In trying to follow the directions to setup log shipping in SQL server 2000 I am having some problems. The option to check "Ship the transaction log to other SQL Server (log shipping)" is not located on the popup screen where I choose the database. It is missing entiurely. Am I missing something somewhere and if so can someone point me in the right direction? I am using SQL Server 2000 Standard Edition Version 8.00.760(SP3).
  2. vbkenya New Member

    I think you might need the Enterprise Edition and a full or bulk_logged recovery model for your database to perform log shipping.

    Nathan H. Omukwenyi
    MVP [SQL Server]

Share This Page