Re: SQL full backup plus log
2004-09-14 13:44:14
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
|
|
|