sql 7 - transaction log bakup file

[croakyfrog]

hi

im trying to backup a sql 7 transaction log - at the moment it's producing one file that is overwritten with each backup (every 2 hours). Is it possible to make it produce a different file for each backup and if so how do i go about doing this?

 

[tlbroadbent]

How are you creating the backup - maintenance plan or your own script? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[croakyfrog]

using maintenence plan