Hi Dave Well I don't mind providing some input and some suggestions if that helps??
We used to Backup SQL Server with an agent, which allowed the Databases to be backed up while it was online. However, due to the costs of the agent, it was decided to get the SQL Admins to configure SQL to perform its own Backups within SQL and place the files on a separate partition. Thus - Each Night we get full backups of the Databases, and SQL can still run without being down. No scripting is used in anyway. Backups are configured as SAN Media Servers using SSO over fibre. Again, this may be withdrawn soon. DBA Administrators SHOULD be responsible for the Databases, but need to be aware if you are backing up using a type of Agent, or if you want them to configure offline copies or "snap shots" I would have thought Netbackup "could" be configured to perform Mounts and Unmounts using a script, however in some of my cases, all Netbackup may do is simply fail with a STATUS code. Unless another script can be run, PRIOR to Netbackup starting the backup process? Maybe DBA Admin again perhaps? Not sure if I have been of much help here, but thought I would reply to give you an idea of what I currently implement. Simon Weaver Technical Support Windows Domain Administrator EADS Astrium Tel: 02392-708598 Email: [EMAIL PROTECTED] -----Original Message----- From: Dave Markham [mailto:[EMAIL PROTECTED] Sent: 09 March 2006 17:10 To: veritas-bu@mailman.eng.auburn.edu Subject: [Veritas-bu] backing up databases Ok, been tasked with giving my input on a backup solution for a new project. Someone had designed it to start backing up things using scripts from cron calling other scripts and then netbackup bpbackup commands and all sorts of random junk. Anyway assume we are talking Solaris 8 or 9 with fiber attached units. The question i have which was from the original design ( and i guess still a requirement ) is how do people go around backing up database volumes. I myself have had dbas ( running oracle ) to do hot_archives and then backup that. The hot_archives are called from bpstart_notify so are captured within netbackup if they take too long or if they fail. I can also do some checking if directories exist etc before running the oracle backup. Also have the added benefit of not writing to tape until exit call from hot_archive which means db backup has finished. Ok, thats one way, the other way i do on another project is use SSO option on the database servers which have dedicated HBA's through fiber to the tape units and shared drives. I just point at a location and assume everything in there is ready to be backed up. This project is slightly different and the DBA's are responsible for the backup. The way this new project is wanting to go is by mounting a storage volume ( disk ) on the db server and writing a backup to it. then unmounting it and then mounting it on the backup server to be written to tape directly. What i want to know is how ( if we have to go this route ) can i control this within netbackup and not start backups unless mount and unmount requests have been done? Do i have bpstart scripts on the db servers, which do the mounts, then the oracle backups and then the unmounts. If this fails can i send something back through bpstart so the backup doesnt run and fails with a certain netbackup code? The benefit of the mount, unmount is so the resource is not used on the db servers to do backups, but im not sure how i am going to control the process within netbackup to capture any errors. So has anyone done anything similar which they can advise with?? Thanks Dave _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu This email is for the intended addressee only. If you have received it in error then you must not use, retain, disseminate or otherwise deal with it. Please notify the sender by return email. The views of the author may not necessarily constitute the views of EADS Astrium Limited. Nothing in this email shall bind EADS Astrium Limited in any contract or obligation. EADS Astrium Limited, Registered in England and Wales No. 2449259 Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu