Re: Question on Database Recovery

No backup eh ?? What about the logical logs ?? I know of no commands that will retrieve a database that has been recently dropped. You're screwed !! If you have the dbschema of the database and a set of load scripts with ascii data then you'll obviously be able to load the data as at the time you unloaded it. If you don't have a level 0 backup or logical log backup then you're back to square 1. ( If anyone out there has a script that can roll back a DROP DATABASE command, I'd also like to use it !!! ) H.Sahar wrote in message <366c4ca2.0@newsread3.dircon.co.uk>... >How I can restore the database after it dropped when there is no backups. >I have a script file that grant database(same database name) to user and >create tables and load unl files. >Is it possible create a database(same name as before) and then run this file >to restore database. > >Any help will be appreciated. > >Shahar > > > >