Colin: The backups seem to take about the same time with or without UD shutdown, on the development server. I just ran a backup on our UD directory and it was 1Gb, compressed to 120Mb, and took about 5 1/2 minutes to create. On one of our client's D3 server, the uncompressed file-save, of the same data, took about 40 seconds and was about 200Mb. I took a look at another one of our clients and their D3 backup was 1.1Gb of a 5-6Gb database, on Windows, and it took 6 minutes to create. In one of our beta accounts, someone created a 12Mb hold entry and somehow Windows showed there were 11.7Gb in the _HOLD_ directory when the item, created on 6/25/07, showed as 12Mb in Windows Explorer. I deleted that item and this problem disappeared (where'd that come from?). I suppose this is just one more of the multitude of problems I've got to keep my eye on! Anyway...
We don't have any transaction processing. The timing starts when the NTBackup starts, after the dbpause. The timing ends when the dbresume is executed, not when it completes. I've been researching backup software and it all seems to point back to Symantec (jeeze!). I was hoping someone would have experience with a high-speed backup product that would backup open files for U2. Since our application has a module that uses ASP.NET we really don't want to shut down the dbms for very long (this is more important than backuping up open files and not having a "pristine" backup). Thanks, Bill >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >[EMAIL PROTECTED] >Sent: Tuesday, June 26, 2007 4:16 PM >To: u2-users@listserver.u2ug.org >Subject: {Blocked Content} RE: [U2] UD Backups > >Bill; > >How long does the backup take on the server if you shutdown UD >first? Just trying to rule out a problem with NTBackup before >getting carried away. > >Do you have transaction processing? DBPause waits for any >writes to complete before it actually stops anything. It >may wait for the entire transaction. Along that line - >would there be anything else that may be holding up DBPause? > >To answer your question - we've mostly used Backup Exec >(there were some issues with older versions of UD). We don't >have anything critical running overnight so we usually leave >UD running and set the "backup open files" and "backup >without a lock" options set. Not sure if it's any faster (I >think NTBackup is a pared down version of Backup Exec). > >We've also had clients use Arcserve successfully, and we even >have one client that backs up to a server on the NET (don't >remember what that product is called). > >hth >Colin Alfke >Calgary Canada >sorry list - I haven't been able to turn off rich-text e-mails >with this >version of Outlook Web Access :-( > >________________________________ > >From: Bill Haskett > >Bill: > >I have the entire backup process scripted and the main script >is called from a >configured Windows scheduled task. Nothing about the >backup process is done from within UD. We have a VB script >included, called >by this main backup script, that deletes old backup >files older than the number of days passed in via the command line. > >Bill >This is a message from the MailScanner E-Mail Virus Protection Service >---------------------------------------------------------------------- >The original e-mail attachment "winmail.dat" >was believed to be infected by a virus and has been replaced >by this warning >message. > >If you wish to receive a copy of the *infected* attachment, please >e-mail helpdesk and include the whole of this message >in your request. Alternatively, you can call them, with >the contents of this message to hand when you call. > >At Tue Jun 26 16:19:00 2007 the virus scanner said: > Could not parse Outlook Rich Text attachment > >Note to Help Desk: Look on the AngelicHost MailScanner in >/home/virtual/site2/fst/var/spool/mail.quarantine/20070626 (message >l5QNIvYF027208). >-- >Postmaster >MailScanner thanks transtec Computers for their support >------- >u2-users mailing list >u2-users@listserver.u2ug.org >To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
