SQL Server Performance Forum – Threads Archive
check box for ‘Ship transaction log to other srvr’I want to implement log shipping but I dont see any check box for "Ship transaction log to other sql server." when I open the dialog box for maintenance plan.I have sql server 2000 with sp3.How to get that check box.
It is only available in Enterprise Edition of SQL Server. If you have standard edition, then you have to use custom built log shipping solutions. Search this forum for some good log shipping solutions.
Log shipping wizard invokes the maintenance plan option in order to workout the log shipping process. Review the information on Books online and in this website about log shipping patterns. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.