How to identify the type of backup file

• koteswara kishore K.

  Ten Centuries

  Points: 1122

  More actions

  October 11, 2007 at 7:39 am

  #375620

  I have a backup file but i don't know it is full backup or transactional log. Now i want to identify backup file type(full/transactional log)using Sql queries

  Help me.

  Kishore KK.

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  October 11, 2007 at 7:55 am

  #741211

  You can use the RESTORE HEADERONLY statement to know exactly what kind of backup file is it...Check BackupType output column

  RESTORE HEADERONLY FROM DISK = N'C:\DatabaseBackups\YourBackupFile.bak'

  --Ramesh
  

  ---

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  October 12, 2007 at 9:05 am

  #741617

  I did a blog post about this a few days ago - Search Engine Q&A #7: Restoring from a backup file containing multiple database backups

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005