Post reply

FILE .BAK problrm with restore DB

  • October 9, 2003 at 6:59 am

    #107175

    I have a .BAK file. I can't rsstore it because i need 38 GB and my hard Disk is 30 GB capable.

    Is Any way to restore only de DB without de Transaction LOG.???????????

    Please Help me.

    Ihave no the original .MDF and .LDF

    Thanks


    Electronics and System

  • October 9, 2003 at 7:33 am

    #477701

    You only have ONE .bak file, correct?

    If so, that's really just the database. You can't restore PART of a .bak file.

    -SQLBill

  • October 10, 2003 at 4:18 am

    #477828

    Hi,

    If this .bak file contains a _single_ full backup of a database, then i don't think you can restore it partialy. But if this file contains several full backups i think you can restore only the last one. try:

    RESTORE HEADERONLY from disk='path to your .bak file'

    and see how many backups you've got there.

    With regards

    Maciej Szymañski


    With regards

    Maciej Szymañski

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

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