Post reply

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

  • October 28, 2010 at 10:27 am

    #228455

    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?

    Thanks!

  • October 28, 2010 at 10:43 am

    #1243704

    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

  • October 28, 2010 at 11:04 am

    #1243717

    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