RESTORE IN SQL SERVER 2005

• SQL*

  SSCertifiable

  Points: 6638

  More actions

  October 5, 2010 at 1:12 am

  #227301

  HI,

  I'm trying to checking the restore option with sql server 2005,

  i have taken the "TEST" Database backup

  and trying to restore the same database "TEST"

  i'm getting the error :

  The tail of the log for the database "TEST" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup the log if it contains work you do not want to lose. Use the WITH REPLACE or WITH STOPAT clause of the RESTORE statement to just overwrite the contents of the log.

  why it is necessary to take transaction log?

  🙂

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  October 5, 2010 at 1:17 am

  #1231484

  The database you are restoring already exists on the server. If you want to overwrite it use

  WITH REPLACE

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉