Post reply

Help required urgent for DB

  • January 10, 2005 at 7:38 am

    #87262

    Hi

    help out me

    Accidentaly i delete one .LDF file among my 2 LDF file,and i have 1 month back backup,

    now how can get my all DB back upto the DAte

     

  • January 10, 2005 at 7:53 am

    #536641

    Try to use a file recovery tool and pray that nothing is overwritten yet. Otherwise I think, you're pretty much out of luck. May I add, that the use of more than one log file doesn't really make sense?

    Actually how can you "accidentally" delete a log? You only can do so when the db is detached or SQL Server is stopped.

    Good luck!

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 10, 2005 at 9:56 am

    #536688

    If file recovery doesn't do it, call MS. They might get you to a stable state. Also, do a full backup of your db file (the .mdf) right now. That's got the data.

  • January 11, 2005 at 10:15 am

    #536859

    This won't be helpful, but there was a cartoon with a "super" DBA who was saying to a colleague "I can fly back in time to recover missing files.  What do you do?"

    I'm anal about my backups.  I wouldn't *ever* permanently delete a file before I'd tested the DB to make sure it worked, unless it was a throw-away.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply