"James Harper" <[EMAIL PROTECTED]> wrote: > > > Actually, the really correct way is to have a backup 'agent' (MSSQL > > > specific fd) that sets up a named pipe and then tells the sql server > to > > > back up to that named pipe. The agent reads the data from the pipe > and > > > sends it (one way or another) to the backup media. > > > > I suppose. It would end-run the problem of having enough disk space > to > > store the text file temporarily. > > It also allows a one-step restore. > > > How do you backup your transaction logs? > > Not sure where you're coming from here so my answer may not match the > intent of your question.
I guess my point was simply that backing up transaction logs is an important part of MSSQL, and generally involves dumping them to ASCII (?) files as well, then doing a second step to get them off to archival media. And I guess my point to that was if you want to make a plugin to backup MSSQL, it's got to get the transaction logs as well. > Under MSSQL, I set up a 'maintenance plan' to back up the transaction > logs to disk each night, and purge them after 7 days. These backups are > then backed up to tape as part of the nightly tape backup. I see this as > an imperfect solution though, but can't exactly put my finger on why. Pretty typical. I've done the same thing for clients. > I always do full backups where possible, but in the case of an > incremental backup, you would do the full database backup at the start > of the backup cycle (eg Monday), and then only the transaction logs for > the remainder of the backup cycle. My mistrust of tapes (bordering on > superstitious :) leads me to believe that a full nightly backup is the > only way to go, otherwise you are pinning the ability to do a useful > restore on more than one tape. Agreed. I have a few clients where the amount of data they have to back up is small enough that (IMHO) it's practical to do a full backup every time. In such a case, I figure it's smarter than dealing with incrementals, where things can sometimes go wrong. -- Bill Moran Potential Technologies http://www.potentialtech.com ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
