Not being SQL literate, is there not an issue with transaction logs with SQL databases? If you don't back them up, SQL doesn't flush commited transactions from what I gathered, I assume that file would simply grow?
jlc > -----Original Message----- > From: Angus Scott-Fleming [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 26, 2008 10:18 PM > To: NT System Admin Issues > Subject: Re: Scripted SQL Backups > > 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> ~ ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
