Find what type of backup a backup files has in it

• gary1

  SSC-Insane

  Points: 21152

  More actions

  February 21, 2012 at 12:17 pm

  #251934

  Hi,

  I have a backup file as Mydb_20120219181004.bak.

  Now, I want to find out what type of backup (full/differential/log) the file has in it?

  Please advise how to find that information

  Thanks

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  February 21, 2012 at 12:34 pm

  #1449918

  Try reading this:

  http://www.mssqltips.com/sqlservertip/1150/what-is-in-your-sql-server-backup-files/

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• Brian.cs

  Default port

  Points: 1407

  More actions

  February 21, 2012 at 12:38 pm

  #1449919

  An easy way is to, through SQL Management Studio, restore the database but before you actually restore it when you first click on the media where you "Specify Backup" click on the backup location of the file and click the "Contents" button. It will show you there.

• Brian.cs

  Default port

  Points: 1407

  More actions

  February 21, 2012 at 12:40 pm

  #1449920

  And also check this directly from Microsoft as well: http://msdn.microsoft.com/en-us/library/ms190747.aspx