Post reply

Need to know about data crashed after swithcing from full at 10am to bulk logged recovey at 10.30am

  • September 19, 2014 at 2:37 am

    #150181

    Hi all ,

    Need to know about data crashed its produciton and it runns 24/7 version is [SQL server 2005 standard ]

    no down time will be provided dataloss will occur in millions of ruppes

    I have a database of size 2TB for which recovery model is Full

    Database is running in full recovery model at 10 m

    some body swithced to bulk logged Recovery

    agin siwthced back to Full Recovery

    but after swithcing to Bulk logged Recovery database got crashed at 10.30 am

    can can we resolve this issue and what are the things to follow

    Thanks

    Naga.RohitKumar

    Thanks
    Naga.Rohitkumar

  • September 19, 2014 at 3:22 am

    #1746634

    You've either had the worse day possible or are asking interview question.

    Is this the same DB you posted the Suspect database thread about? If so, I answered there.

    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

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

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