Post reply

plase help me

  • April 23, 2012 at 4:18 am

    #256778

    hi all

    my database is crashed suddenly, now i want add my mdf and ldf file using power shell plz help me!!

    --------------------------------------------------------

    I am Learner -- SQL

  • April 23, 2012 at 4:49 am

    #1477385

    Even if you attach the mdf and ldf file using PowerShell, it will attach the files which actually crashed....right??

    Shouldn't you be looking at other options like restoring a backup of the database?...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • April 23, 2012 at 5:11 am

    #1477401

    Forget powershell. It's irrelevant.

    Please define 'crash'. Exactly what happened? Exactly what state are things now?

    Do you have a backup?

    Do you have the mdf and ldf files?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 23, 2012 at 5:28 am

    #1477416

    i have only MDF and LDF files.

    --------------------------------------------------------

    I am Learner -- SQL

  • April 23, 2012 at 5:33 am

    #1477420

    selvakumar.sms (4/23/2012)

    i have only MDF and LDF files.

    By avoiding Gail's questions you are making your own questions more difficult to answer. Please reread her post and then provide the requested information.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • April 23, 2012 at 5:38 am

    #1477422

    GilaMonster (4/23/2012)

    Please define 'crash'. Exactly what happened? Exactly what state are things now?

    No backup? Seriously you have no backup? I'm going to assume, since there's no backup, that the DB isn't very important.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 24, 2012 at 2:12 am

    #1477957

    You still haven't told us what you mean by "Crash"

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • April 24, 2012 at 3:03 am

    #1477977

    thanks alot

    finally i attached mdf and ldf using sp_attach_db procedure.

    --------------------------------------------------------

    I am Learner -- SQL

  • April 24, 2012 at 3:09 am

    #1477981

    You are magician 😉

    Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.

Viewing 9 posts - 1 through 8 (of 8 total)

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