Post reply

DB in Recovery Pending

  • July 11, 2014 at 2:57 am

    #309888

    Hi Experts,

    Our DW database having size 6TB is in recovery pending state because of space issue in that drive. How can we resolve this issue?

    Since the db is not online we wont be able to add a new file to another drive right.

    TIA

  • July 11, 2014 at 2:58 am

    #1728636

    What are the messages in the error log?

    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

  • July 11, 2014 at 3:38 am

    #1728650

    Thanks a lot Gail.

    S:\LOG\ABC_Log_508.ldf: Operating system error 112(There is not enough space on the disk.) encountered.

    To allow recovery to succeed, the log file 'ABC_log5' has been expanded beyond its maximum size. After recovery completes, you should either increase the size of the log file in the database or schedule more frequent backups of the log (under the full or bulk-logged recovery model).

  • July 11, 2014 at 4:08 am

    #1728662

    Is that the only message?

    Can you move files off S drive to free up space?

    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

  • July 11, 2014 at 4:32 am

    #1728669

    Only mdf and ldf files of that particular db exists in that drive.

  • July 11, 2014 at 4:59 am

    #1728678

    Can you expand the drive?

    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

  • July 11, 2014 at 7:46 am

    #1728750

    We have requested infrastructure team for that..

    Is there any other way to handle this.

    Thanks Again Gail.. You are my Guru..

  • July 11, 2014 at 8:00 am

    #1728752

    Probably, but they're far less preferable ways than expanding the drive.

    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

  • July 14, 2014 at 7:12 pm

    #1729311

    What is the recovery model of the dw?

  • July 15, 2014 at 12:59 am

    #1729329

    Shaun Finnegan (7/14/2014)

    What is the recovery model of the dw?

    Simple Recovery

  • July 15, 2014 at 4:21 am

    #1729381

    Ratheesh.K.Nair (7/15/2014)

    Shaun Finnegan (7/14/2014)

    What is the recovery model of the dw?

    Simple Recovery

    expand the drive, then plan to add another separate drive (RAID 10 if possible) and move all you log files to this drive.

Viewing 11 posts - 1 through 10 (of 10 total)

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