sql2000

Question

pls tell me abt log shipping in sql2000

 

Answer 1

Pls check the below links for log shipping in Sql 2000,

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1361.mspx?mfr=true

the concept is the same as in sql 2005,

• take T-log backup in source
• copy that to destination server
• restore the t-log in destination using with standby option

- Deepak