SQL Server Performance

Transaction log backup script

Discussion in 'Contribute Your Performance and Clustering Tips' started by dktiger, Sep 3, 2003.

  1. dktiger New Member

    Hello,

    We have operated with Win2K, SQL Server2000 which recovery model is "FULL" and Hitachi BOX(lightening 9900A).

    After syncing product DB with shadow image in the BOX, we'd like to back up w/ transaction log included truncate option.

    Sync schedule will be tried every 4 hours a day.

    How can we make the script?

    Please, let me know the resolution w/ script.

    Thanks in advance.

    Ted Kim
    Sr. System Engineer
    CJ Systems
  2. satya Moderator

  3. gaurav_bindlish New Member

    Refer BACKUP LOG in books online.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Share This Page