HI All, I need to perform log shipping from primary server to secondary server.But production environment the SQL serevr 2000 setup is Standard edition with sp4. This Standard edition allows you to perform log shipping through Database maintainance plan or not? I came to know that Enterprice Edition will support log shipping through Maintainance wizard. Please can anyone suggest me on the same. Cheers, Thulasi R.
There is no built-in log shipping in standard edition, you can use the scripts to accomplish the same... You can find many script when you google "SQL server 2000 custom log shipping" Check the following links... http://www.sqlservercentral.com/articles/Administering/customlogshipping/1201/ http://www.google.com/search?source...53US253&q=sql server 2000 custom log shipping
Thanks mohammed ,,,,I have one more question like related to SQL Mail Configuration in SQL Server 2000. I want to configure mail for jobs,when the job completed successfully i need to receive a notification through mail confirmation. I am trying to configuring the mail but its asking like MAPI account.DO u suggest me on this whether the SQL Server Standard Edition will support SQL mail or not? Thanks, Thulasi R