Angus, I will talk with my SQL DBA and see the SQL code he uses to do the backups to disk each night in the SQL jobs and send ya a code snippet. This should be easy to do with a SQL job.
Z Edward E. Ziots Netwok Engineer Lifespan Organization MCSE,MCSA,MCP,Security+,Network+,CCA Phone: 401-639-3505 -----Original Message----- From: Angus Scott-Fleming [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 27, 2008 12:18 AM 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> ~
