If we are talking about SQL 2000;

Go to Enterprise manager; expand tree sql server group; server name; databases; 
database name. Right click and go to properties for database. In Options tab 
you will see recovery model. Change it to full.

While you are there click on help and search for "Transaction log backup".

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 1:44 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL full backup plus log


thanks for the answer ...
I'm trying to find the SQL recovery mode ... don't fing it ... any idea 
where to see or configure it

thanks again

Luc Beaudoin
Administrateur Réseau / Network Administrator
Hopital General Juif S.M.B.D.
Tel: (514) 340-8222 ext:8254 






Joe Crnjanski <JCrnjanski AT INFINITYNETWORK DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-09-14 11:34 AM
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        cc: 
        Subject:        Re: SQL full backup plus log


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