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"
