Post reply

Transaction log.

  • July 5, 2005 at 10:32 am

    #88092

    Okay new question. There is a DB called phone, and the phone.mdf has been damaged. So you rebuild the database. Is there a way to use the old phone.ldf?  No backups to do a restore from. I know I am grasping at straws but I am tring to get as much data as I can back.

     

    Note: (The DBA responsable for this mess is still walking upright...for the moment! )


    Stacey W. A. Gregerson

  • July 5, 2005 at 10:40 am

    #570927

    Don't think so!


    * Noel

  • July 5, 2005 at 10:45 am

    #570930

    Okay I guess the DBA will soon be wlking with a limp, or removing a my size 11 shoe from somehere not so nice.


    Stacey W. A. Gregerson

  • July 5, 2005 at 11:02 am

    #570939

    or like someone here like to say. Time to:

    exec sp_update_resume

    followed by

    exec sp_distribute_resume

     


    * Noel

  • July 5, 2005 at 11:20 am

    #570943

    How did the file get damaged anyways?

  • July 5, 2005 at 11:23 am

    #570946

    Hardware errors. You look at the file names and the size on the MDF is 0.


    Stacey W. A. Gregerson

  • July 5, 2005 at 11:27 am

    #570949

    He can't blame you for hardware problems.

    He can blame you for not backing it up and himself for not making sure you backed it up though .

  • July 5, 2005 at 11:49 am

    #570959

    I dont deserver any of the blame as it is owned by another DBA that as you can see did not do his job. I was trying to help. T

     

    Thanks everyone for look at this. I was pretty sure that there was little hope.


    Stacey W. A. Gregerson

  • July 5, 2005 at 12:00 pm

    #570965

    I C, good luck anyways.

  • July 5, 2005 at 1:23 pm

    #570989

    Staci,

    Silly question but did you look for any backups on disk?

    Zach

     

     


    John Zacharkan

  • July 5, 2005 at 1:40 pm

    #570995

    That is the reason I am gaoing to plant my size elevens in the other DBA's back side.  He never made any backups of the databases. He "ASSUMED" that the database would automatically backup.


    Stacey W. A. Gregerson

  • July 5, 2005 at 1:59 pm

    #571002

    How can a real DBA assume that???????????

  • July 5, 2005 at 2:22 pm

    #571019

    GOOD Question!


    * Noel

  • July 6, 2005 at 5:35 am

    #571159

    I thought that he had a Maintenance plan set up to get all non system databases every night.

     

    I have had a long talk with him on the subject. I hope that this has been a good learning experiance.

     

    Thanks for all the replies.


    Stacey W. A. Gregerson

  • July 6, 2005 at 11:49 am

    #571415

    Thanks for remembering the 'proper' stored procedure execution Noel !!!

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 1 through 15 (of 17 total)

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