Post reply

Current t-log file running parallel

  • June 17, 2005 at 3:14 pm

    #89843

    How can i store current transation log file at two place (Parallel mode). If i loose the one current log file then still i can able to retreive point of brake data by using other t-log file.

     

     

    Thanks,

  • June 19, 2005 at 1:28 am

    #566626

    You can't do that. Instead, place your log file on RAID 1 (mirrored) drive - thus you are protected against single media failure. To be able to recover as much data as possible in the event of server failure - use frequent tr. log backups or high availability features (log shipping, replication, clustering) - what suits you needs best.

  • June 20, 2005 at 10:17 am

    #566793

    Or cut logs more often (back them up) and copy them to another file system.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply