Post reply

i deleted a recently attached database in management studio, is it gone?

  • January 26, 2006 at 2:19 pm

    #170733

    hiya,

    I right clicked the database in management studio, and accidentally hit "DELETE".I now can't find the corresponding  .MDF anywhere on my hard drive..or in the recycle bin.

    Is this .MDF gone forever?Can I at least salvage the scripts that created the schema?

    yours in hope,

    yogi

  • January 26, 2006 at 2:22 pm

    #617323

    I can't speak much for SQL Server 2005, but if you do that in 2000, you're toast.  Your files are gone forever, with the exception of taking your harddrive into a place that can salvage the data.    Do you have a backup?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • January 26, 2006 at 2:27 pm

    #617325

    Hiya,

    No John, no backup. It was only a few tables that I am working on in my own time.A lesson learned.

    Thanks bud,

    yogi

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

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