none
Online transaction log backup for SQL 2000 RRS feed

  • 問題

  •  

    Hi,

     

    We have SQL 2000 server, the database and transaction log size is very large. Since we couldn't suffer the data lose more than 30 minutes. So I think we need to perform online transcation log backup, have any efficiently method and proceudres to do it, pls advise, thx.

     

    Regards

     

    James

    2008年8月21日 上午 08:05

解答

  • You can create db maintenance plan to do full and log backups, schedule to run log backup every 30 minutes. 

     

    2008年8月21日 下午 03:01

所有回覆

  • You can create db maintenance plan to do full and log backups, schedule to run log backup every 30 minutes. 

     

    2008年8月21日 下午 03:01
  • Hello rmiao

     

    This is Angela Ip from Microsoft Hong Kong. I am please to inform you that you are one of the Top 10 Answerers of last quarter!

     

    We would like to invite you to join the community gathering at which we will present you a prize to acknowledge your contribution to the community. Please kindly send an email to hkdevcom@microsoft.com so I can have your contact for further conversation.

     

    Many thanks for your support to the forum again!

     

    Best,

    Angela Ip (MSHK)

    2008年9月18日 上午 12:34