As Richard S. says; you have to go back to the books.

Check "TDP for Microsoft SQL Server Installation and User's guide" pdf manual 
that comes with the Installation CD. Appendix C tells you how to setup TDP 
using Central Scheduler.

If you are doing log backup remember to change SQL recovery mode from simple to 
full; and TEST IT, TEST IT, TEST IT!!!!

Good luck!!!

Joe Crnjanski
Infinity Network Solutions Inc.
Phone: 416-235-0931 x26
Fax:     416-235-0265
Web:  www.infinitynetwork.com



-----Original Message-----
From: Luc Beaudoin [mailto:lbeaudoi AT IS.JGH.MCGILL DOT CA]
Sent: Tuesday, September 14, 2004 10:51 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL full backup plus log


Hi all

Is there anyone that are doing FULL SQL plus FULL LOG BACKUP every day...

If yes ... what is the way to do it with the scheduler and an option file

thanks

Luc