Post reply

Restoring only Data file

  • April 24, 2007 at 10:52 am

    #153545

    Hi,

    I have complete database backup(database.bkp file). Due to space constraints, i would like to restore only the Data part and NOT the log file. Pls let me know if this is possible from the complete database backup set?

    Thanks in Advance

  • April 24, 2007 at 1:14 pm

    #702239

    You can't do that.  You restore a database to the state it was in at a point in time.  In your case, that's the point when the complete backup was taken.  This means that the data and transaction log are restored to that point. 

    Greg

    Greg

  • April 25, 2007 at 2:51 am

    #702318

    Thanks for the reply.

    Vivek

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

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