Ahh... Restoring from backup is not that bad. Boot the users from the system, kill all the connections to get exclusive control, dump and load, dump and load. Since this is Sql Server the process is somewhat easier than some of the other platforms. (I remember back in the day when I used to walk ten miles to school up hill both ways in a snow storm... Ahh... Wait a moment... Wrong topic... First thing to go when you hit my age - ahem - 36 ...)
Anyway - setting the humor aside for a moment - if you restore your backup from your production system into your development environment all of the user accounts that you have in your production environment will suddenly have access to your development box. Now I point this next part out in case your set up similar to some of the other places which I have seen in which the production fixed license count differs from the development. If you have a significant amount of users in your production environment that have fixed licenses assigned, those users will be stored in the user_cache. When you load the database, the user_cache is also loaded because it is a part of the same database. So - now you can login, but who gets a fixed license? Well, it is going to depend upon which one of those users connects to the server in question and in the order that they connect. In short, if your have people testing on the machine, and you as the administrator come in, there is no guarantee that you will recieve a fixed license. Cute, huh? If you copy the development server over, update the records in the user form and give them read licenses, grant the administrator fixed and reload the cache. Otherwise, somewhere down the road you might end up in a situation in which arcache is your friend. -Will On Tue, August 29, 2006 13:48, McKenzie, James J C-E LCMC HQISEC/L3 wrote: > Dan: > > > So this may become a legal issue. I would definitely take a stab at the > backup tape and see what happens. I do know that Oracle is really picky > about the way that you did the backup. However, I have cold backed up > and restored out of Oracle using SQLPlus and the old backup commands on > UNIX. > > > James Mckenzie > L-3 GSI > > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Dan Caissie > Sent: Tuesday, August 29, 2006 10:39 AM > To: [email protected] > Subject: Re: Ok I have a question. > > > > ** > > > I do have a dev system. > > > The one ticket in question was for a change control so they are worried > about an audit, and yes I would love to just re-create this ticket. > > I'll give a try at restoring the database. > > > Fun Fun Fun, > > > > > > > Dan Caissie > > > Remedy Administrator / Developer > > > United Natural Foods, Inc > > > 260 Lake rd > > > Dayville, CT 06241 > > > (860) 779-2800 > > > Ext: 32380 > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Bob > Sent: Tuesday, August 29, 2006 1:09 PM > To: [email protected] > Subject: Re: Ok I have a question. > > > > > For one ticket? I mean, 1 out of how many thousand per month? Is anyone > going to miss 1 ticket? I think that the most I would do is retype the > thing. If I wanted to be really clever I would create an import record > by hand and then import it, which would allow you to set the record ID and > the date(s). But I wouldn't touch a backup for just 1 ticket. > > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC > HQISEC/L3 > Sent: Tuesday, August 29, 2006 1:03 PM > To: [email protected] > Subject: Re: Ok I have a question. > > > > > Dan: > > > Do you have a development machine or a machine where you can throw the > database backup onto? > > James McKenzie > L-3 GSI > > > > ________________________________ > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Dan Caissie > Sent: Tuesday, August 29, 2006 9:46 AM > To: [email protected] > Subject: Ok I have a question. > > > > > ** > > > 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 > > > > > __20060125_______________________This posting was submitted with HTML in > it___ __20060125_______________________This posting was submitted with > HTML > in it___ > > __20060125_______________________This posting was submitted with HTML in > it___ __20060125_______________________This posting was submitted with > HTML > in it___ __20060125_______________________This posting was submitted with > HTML in it___ > > > _________________________________________________________________________ > ______ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
