Post reply

differential restore

  • April 28, 2008 at 6:09 am

    #380232

    hi friends :O)

    i wanna restore my backaup file differentially.

    i know this TSQL:

    RESTORE DATABASE TestDB

    FROM DISK = 'C:\backup'

    but it restore DB normally !how can i do it with TSQL ?

    Thank for your notation

  • April 28, 2008 at 6:24 am

    #807701

    First of all, you need already to have a full backup and a differential backup of your database. If you do, then restore from the full backup with no recovery, then restore the differential backup with recovery. Books Online has the full syntax together with some good examples.

    John

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

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