That also has advantages in the fact that you would then have a development machine that is an exact match of the production (Skipping the last drop and reload).
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of arslist Sent: Tuesday, August 29, 2006 11:57 AM To: [email protected] Subject: Re: Ok I have a question. Personally, I would go over to the development server, take a backup and kick it in the head. Load your backup database over there and bring the AR System server up. Go into the UT, locate the record in question and export it to an ARX. Once done, you can use the ARImport tool to import the record back into your production environment. Now the reason for using the development server is simple: less mess and less fuss. If you try to do a literal import, or copy and paste, or export and import there are referentical integrity issues to consider (a record is comprised of data in a Tnn table, an Hnn table, and a Bnn table - and there could be more than one Bnn table depending on the number of attachment pools in your form.) Once done, drop the development database and reload it from the dump that was taken when starting. Just some thoughts. HTH. -Will On Tue, August 29, 2006 11:46, Dan Caissie wrote: > Since it's so slow here I have a question. > I'm trying to restore a help desk record that somehow got deleted. > What would the best way to do this? > I do have a copy of an earlier back-up of the database. > Windows Server, SLQ 2000, AR Server 6.03 patch 005 > > Thanks, > Dan Caissie > Remedy Administrator / Developer > United Natural Foods, Inc _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
