The only suggestion I can give you is to look for something distinct between the environments. In our case on Oracle we have different dbLinks (which are different on dev/test/...)
Another way might be to look for different data in one of the tables (i.e. I use a different login on each environment so that would be different on dev/test/...) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of manoj jain Sent: Friday, July 24, 2009 10:41 AM To: arslist@ARSLIST.ORG Subject: very interesting issue Hi Remedians, I need to restore the database from a backup copy. I have 20 backup copies with just date and no name. I need to login into each database and need to identify if this is the right database. These 20 db can belong to prod or qa or dev. So is there any way to identify right backup? Thanks & Regards, Manoj Jain _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"