Log Shipping

Does anyone know the procedure (if it exists) to manually configure log shipping. I

Don’t have SQL Enterprise Edition only Standard. Thanks for everyone being there

to help.

SQL 2000 Standard Edition SP4



Answer this question

Log Shipping

  • Brian101

    You can't configure log shipping through the wizards in SQL 2000 Standard, only the Enterprise version. To manually configure it have a look at this article. http://www.sql-server-performance.com/sql_server_log_shipping.asp -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com wrote in message news:4877f564-3192-498d-b84d-a418c79a4f3f@discussions.microsoft.com... Does anyone know the procedure (if it exists) to manually configure log shipping. I Don't have SQL Enterprise Edition only Standard. Thanks for everyone being there to help. SQL 2000 Standard Edition SP4
  • williware

    Thanks for your answer. Can you direct me to some white papers that describe the process


  • venumadhav

    In SQL Server 2000, log shipping is configured using the GUI which creates all of the appropriate jobs, with everything linked in correctly.

    SQL Server 2005 allows everything to be scripted and deployed using T-SQL.



  • Log Shipping