How to find backup type (differential or full) from restore filelistonly output

Question

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

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Use RESTORE HEADERONLY, that will tell you what type of backup the native backup file contains.

ak_saravanan SSC Enthusiast Points: 149 More actions · Answer 2

SSC Enthusiast

Points: 149

January 15, 2010 at 3:14 pm

thanks . i see the backup type.