Chris- This is what our DBA has planned for now: "Before we go DSO route, I would like to explore following methods in SQL Server to get data to backup server: 1. Log Shipping 2. Snapshot 3. DTS package"
I'm not much of a DBA- I stay out of it as much as I can, so I'm not sure which, if any, of these options you mean by mirroring. We want no more than 15 min latency so DSO isn't a god option, but we were told by BMC that's the only sort of mirroring they support. After the debacle with transactional replication we're nervous about trying anything else and are setting up a virtual dedicated test server just to play with the different options. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Monday, July 28, 2008 12:01 PM To: [email protected] Subject: Re: Hot Backup Servers Did you try database mirroring? Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Monday, July 28, 2008 11:56 AM To: [email protected] Subject: Re: Hot Backup Servers ** Ben- We're working on a similar solution, but one word of caution- we tried setting up a mirror DB using SQL transactional replication and the first time we made an administrative change to a form (adding a field via the Class Manager) our system got all kinds of messed up. Of course, using transactional replication the parent DB isn't supposed to be altered in any way, but for reasons neither BMC nor MS can figure out beyond finger pointing, it did. It seems the schema table was altered and was pointing to views and tables which we either incorrect or thought objects that existed already didn't and tried to create them. We had to recover from a week old backup and import all new and updated tickets and was a nightmare weekend. Anyway, be careful using transactional replication. 7.0.1 p5 SQL 2005 sp2 Chris ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin Trimmer Sent: Monday, July 28, 2008 11:39 AM To: [email protected] Subject: Hot Backup Servers ** Who has implemented a hotbackup server in a 7.x environment? In 6.3 and prior, it was relatively simple (license-wise) since the licenses were in a file, and not the database. How does, or what is the best way, it should work in a 7 environment since the licenses are not in the database? We thought of having a seperate "standby" database instance that would get updated via a SQL transaction log. The problem, however, is that if the PRD system went down, we'd have to do something with the license to get it to work. Thoughts? Ideas? Thanks, Ben Trimmer * * * * * * * * * * * * * * * * * * * * * * * * * IMPORTANT NOTICE* * * * * * * * * * * * * * * * * * * * * * * * * Unless otherwise indicated or obvious from the nature of the transmittal, the information contained in this email message is CONFIDENTIAL information intended for the use of the individual or entity named herein. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender using the above contact information or by return email and delete this message and any copies from your computer system. Thank you. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
