InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:51:08 GMT20http://www.sqlservercentral.com/Forums/Topic491317-357-1.aspxFirst 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.JohnMon, 28 Apr 2008 06:24:48 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic491317-357-1.aspxhi friends :O)i wanna restore my backaup file differentially.i know this TSQL:[b]RESTORE DATABASE TestDB FROM DISK = 'C:\backup'[/b]but it restore DB normally !how can i do it with TSQL ?Thank for your notationMon, 28 Apr 2008 06:09:00 GMTdr_csharp