You are correct that they should be obsolete as the 4.5 version of Remedy introduced the @ as current server in the metadata.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bob Wallace Sent: Wednesday, February 28, 2007 3:02 PM To: [email protected] Subject: Re: Dev server DB from backup of PROD - UPDATES required SQL Serv er 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"
