-
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
-
Forum Rules
|
|