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).
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]