Hi All I have two server. source server : headsql db name : Stores Backup Folder : d:logshipping designation server : backupserver db name : stores shared folder : \backupserverlogshipping i need step by step guid to configure logshpping using tsql. ie. using sp_add_log_shipping_plan sp_add_log_shipping_database etc.... Thanks S. Ramesh
http://www.sql-server-performance.com/sql_server_log_shipping.asp http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx too.. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.