Notes below. Summary - this is like taking offline backups of Exchange. On 2/26/08 9:18 PM, "Angus Scott-Fleming" <[EMAIL PROTECTED]> wrote:
> On 26 Feb 2008 at 16:17, Joseph L. Casale 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 >> >> > > If you don't need the databases 24*7, you could easily set up a Scheduled Task > that ran a batch file that does the following: > > NET STOP "SQL Server" > XCOPY \\path\to\dbs \\path\to\backup /m/i/s/c/h > NET START "SQL Server" > Angus, This will do nothing in terms of committing transactions to the database and flushing them from the transaction logs. While it WILL work, since you can attach the flat files in SQL server in a far simpler manner than you can attach messaging databases in Exchange, it is not an optimal backup form. This is one of the things I don't like about MySQL... There isn't a way to perform a "hot" backup, since a MySQL backup really is just a script to recreate the database. > This would copy any altered files in the source dir to the target dir. > > Might need to change "SQL Server" to the exact service(s) that your > SQL-server- > of-choice uses. ISTR having several services that needed to be stopped in a > certain order when I was mangling a SQL server box a few years ago and the > client wouldn't spring for the SQL-server modules for BackupExec. > > HTH > > -- > Angus Scott-Fleming > GeoApps, Tucson, Arizona > 1-520-290-5038 > +-----------------------------------+ > > > > > ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ > ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~ ----- Salvador Manzo [ 620 W. 35th St - Los Angeles, CA 90089 e. [EMAIL PROTECTED] ] Auxiliary Services IT, Datacenter University of Southern California 818-612-5112 --- "Sometimes it is said that man can not be trusted with government of himself. Can he, then, be trusted with the government of others? Or have we found angels in the forms of kings to govern him? Let history answer this question." -- Thomas Jefferson (First Inaugural Address, 3/4 1801) ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
