RESTORATION ISSUE

• vreddytg

  SSC Rookie

  Points: 45

  More actions

  January 8, 2015 at 11:11 pm

  #296421

  Hi All

  I Restored Database Almost 93 % Completed After I Got Below Error:

  Msg 4333, Level 16, State 1, Line 1

  The database cannot be recovered because the log was not restored.

  Msg 3013, Level 16, State 1, Line 1

  RESTORE DATABASE is terminating abnormally.

  Please help .....

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  January 9, 2015 at 4:14 am

  #1769014

  It's likely that someone canceled the restore. Drop the existing database and start the restore again.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  January 9, 2015 at 7:44 am

  #1769087

  are you restoring over a current DB on the same box? So in other words, are you restoring the DB over itself?

  Post the restore stmt you're using.

  But by all means, try what Grant said first.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: