There are a number of things you may want to update, it depends on your environment. The email mailbox configurations, misconfigured servers that store server names/aliases in table fields or push/set field operations, among others. I do not have my script handy at the moment to see all the places that need updating.
Axton On 2/28/07, Bob Wallace <[EMAIL PROTECTED]> wrote:
Hello Craig, and Sandra Thank you for the information. I think that the "sp_changedbowner ARAdmin, true" SQL statement is a "command line" alternative to the GUI approach described by Craig. My memory was not of the sp_changedbowner. I was something like "UPDATE dbo.metadatatable SET columnname = 'newservernm'. We just recently "upgraded" from ARS 4.0 to 6.3. I went back to the 4.0 database and looked at the metadata tables to try to jog my memory. This is a total guess but I think I was remembering something like UPDATE field_table SET tfserver = ... There is a tfServer column in the version 6.3 field_table, but that field currently only contains "$-6$" or "@". Maybe the switch to @ as a "current sever" has made those update statements obsolete. Thank you again. On Wed, 28 Feb 2007 12:07:05 -0700, Carter, Craig J Civ ARPC/DPD <[EMAIL PROTECTED]> wrote: >Bob, > >We have the same setup. > >All we do is backup the production database, copy it to the dev server, stop >the Remedy services on the dev server, and restore the prod database backup >to dev. Afterwards, go into Enterprise Manager and set the ARAdmin account >to dbo and public for the dev database and restart the services. > >Piece of cake--no SQL queries required. The only other thing we do is reset >the outgoing email address for the dev server (AR System Email Mailbox >Configuration form--advanced tab) so emails originating from dev show the >correct address. > >CRAIG J. CARTER > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Bob Wallace >Sent: Wednesday, February 28, 2007 7:35 AM >To: [email protected] >Subject: Dev server DB from backup of PROD - UPDATES required SQL Server > >I know that this has been asked and answered but I can not find it in the >archives nor can a find a copy which I kept. I apologize, in advance, for >asking again. > >Would someone please forward the series of UPDATE statements which are >required when a backup of the production database is used to refresh the >database on a dev server. >Or a better search key word to identify the post in the archives; I >tried "COPY" and "UPDATE DBO.", as well as a visual scan. > >We are using ARS 6.3, with HD 6.0, running on W2K3 server accessing SQL >Server 2000. > >Thank you, >Bob Wallace > >___________________________________________________________________________ _ >___ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the >Answers Are" > >___________________________________________________________________________ ____ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" >========================================================================= _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
