none
SQL2000 online transaction backup RRS feed

  • 問題

  •  

    Hi,

     

    We have SQL2000 database, the database size & log file size is very large, then how can we online backup the transaction log file, since we need to recover the database point in time. I think that we should online copy the log file for backup, say every 5 minutes. Could we have any efficiently method to do it ?

    Regards

     

    James

    2008年8月21日 上午 08:00

解答

所有回覆

  • You can't copy log file without shut down sql service, check my response in your other post.

     

    2008年8月21日 下午 03:05

  • Can we online copy the log file for exchange 2003 ? Any other method for online sql backup, say sql 2000 or latest version ?

    2008年8月22日 下午 01:21
  • You can backup db and log with sql backup statement, it's online process. Don't know exchange since it's not on sql.

    2008年8月22日 下午 04:54