Home Forums SQL Server 2008 SQL Server 2008 - General Differential restore without full backup restore!! RE: Differential restore without full backup restore!!

  • July 6, 2013 at 2:28 pm

    #1630244

    S_Kumar_S (7/6/2013)

    HI

    ...Do I always need to do a full database restore of ServerA with NORECOVERY and then Apply differential with RECOVERY?

    Yes.

    http://msdn.microsoft.com/en-us/library/ms175526.aspx

    "A differential backup is based on the most recent, previous full data backup."