System.Data.SqlClient.SqlError: The log or differential backup cannot be restored

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  October 20, 2009 at 5:34 am

  #211169

  Dear All,

  By mistake I have used with Recovery option when I was in the middle of restoring the back up.Should I delete this middle level backup and again start the same restoration process,or is there any option for take the database into No recovery mode...

  Bcoz I am getting error of :System.Data.SqlClient.SqlError: The log or differential backup cannot be restored because no files are ready to rollforward.

  Thanks

• Jeffrey Williams

  SSC Guru

  Points: 90303

  More actions

  October 20, 2009 at 1:10 pm

  #1068464

  If you were not done - then you have to start the restore over.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs