Sorry Prakash,

I don't think you have any chance of getting back your table as you do
not have any backups. That would be great if you can share your future mails
on this topic here in this Forum. Quite a dizzy thing .... Table is gone and
not backup....


-----------------------------------------------
Rahool Moray
IT Specialist
vMoksha Technolgies Ltd
+91 20 4121454
-----------------------------------------------
----- Original Message -----
From: "Mandeep Bhutani" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, December 31, 2003 14:33 PM
Subject: Re: Sql Problem


> Hi
> If u have any full backup and the recovery mode is
> full, perform following tasks:
>
> Take transaction log backup of the database.
>
> Apply the RESTORE DATABASE using following syntax:
>
> RESTORE DATABASE DB Name
> FROM disk='full backup path'
> WITH NORECOVERY
> GO
> RESTORE LOG DB Name
> FROM Disk='Transaction Log backup path'
> WITH RECOVERY, STOPAT = 'specify the point in time
> till u want to recover the data' for e.g.
> Nov 1, 2003 11:30 AM'
>
> Switch the database in a single user mode.
>
> Hope this will work.
>
> Do revert back in case of any concerns.
>
> Regards
> Mandeep
>
>
>
> --- Prakash <[Email Address Removed] wrote:
> > dear gurus
> > by mistake my cooligue has dropped a table which was
> > having 100 critical
> > record.I dont have backup which includes this
> > table.How can i get this
> > table.
> >
> >
> >
> ---------------------------------------------------------------------
> > TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> > JUST REPLY
> > Get today's cartoon: http://www.LazyDBA.com
> > To unsubscribe, e-mail:
> > mssqldba-[Email Address Removed] > For additional commands, e-mail:
> > mssqldba-[Email Address Removed] >
>
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page