Results 1 to 5 of 5

Thread: transaction log backups... a few questions.....

Threaded View

  1. #1
    Join Date
    May 2003
    Posts
    35

    transaction log backups... a few questions.....

    Hi,

    I am doing a daily full backup of all the databases.I want to backup the transaction log with a tsql like this...


    backup log xyz_db to
    disk ='k:\sqllogbkups\xyz_db.trn'
    with noinit,no_truncate


    I understand the once xyz_db.trn is saved on tape... I have to run a job with the options "with init,truncate only"

    Is this correct ?
    or should I follow some other way of backing up transaction logs....?


    Thanks,
    Copernicus..
    Last edited by copernicus; 06-17-2003 at 02:28 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •