Is it possible to just restore the data partition without the log?

  • If I wish to restore a database in another environment which I don't need FULL recovery mode, normally, I do the restore and then change the database to SIMPLE, truncate the log and shrink it. The log file however, is large and it still does require the disk space during the restore.

    Is it possible to skip that log restore since it's not needed anyways?


  • No.

    The log is needed. It's not an optional portion of the database, it's necessary for the restored database to be transactionally and structurally consistent.

    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
  • Ugh! I was afraid I see that answer coming my way.

    Thanks for confirming that Gail. I really appreciate it!

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

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