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" 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> ~
