If it is Oracle, this query will return the database name: SELECT name FROM v$database
With the default permission setup you will need the DBA role to run it. Not sure if there is a MS SQL version. Juan Ingles On Fri, Jul 24, 2009 at 8:40 AM, manoj jain <manoj.jain4...@gmail.com>wrote: > ** Hi Remedians, > > I need to restore the database from a backup copy. I hvae 20 backup copies > with just date and no name. > I need to login into each databse and need to indetify if this is the right > database. > These 20 db can belogng to prod or qa or dev. > > So is there any way to identify right backup? > > Thanks & Regards, > Manoj Jain > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"