MS SQL 2000 Database Maintenance Plans MS SQL 2005 Database Maintenance Wizard plus some custom SSIS tasks if you¹ll also be doing differentials. (Microsoft made this interface needlessly confusing, IMO).
SQLExpress (also applies to MSDE) http://www.sqldbatips.com/showarticle.asp?ID=27 http://www.sqldbatips.com/showarticle.asp?ID=29 MySQL http://dev.mysql.com/doc/refman/5.0/en/backup.html http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Databas e/ On 2/26/08 3:17 PM, "Joseph L. Casale" <[EMAIL PROTECTED]> wrote: > I¹ll admit I have _never_ used sql am not sure what to do here. > > I have a slew of small DB¹s I need to script a nightly full of to a directory > which gets backed up to tape. > > Can someone push me in the right direction, being that I don¹t really know > anything about SQL, I don¹t know if the various points I am reading are > correct/optimal J > > Thanks! > jlc > > > > > > > ----- Salvador Manzo [ 620 W. 35th St - Los Angeles, CA 90089 e. [EMAIL PROTECTED] ] Auxiliary Services IT, Datacenter University of Southern California 818-612-5112 The injury which may possibly be done by defeating a few good laws, will be amply compensated by the advantage of preventing a number of bad ones. -- Alexander Hamilton, Federalist No. 73 on the veto power ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
