BAK File

Question

BAK File

Tara-1044200

SSCoach

Points: 15951
More actions
February 8, 2010 at 11:47 am

#220425

How do i know if a backup file is full backup or differential backup or anything else ?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Amit Singh Ten Centuries Points: 1295 More actions · Answer 1

check the backupset table in msdb on the source of the backup server, it would have the type of backup and the file name

-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]

Amit Singh Ten Centuries Points: 1295 More actions · Answer 2

also you could try this

RESTORE VERIFYONLY FROM backup_device WITH LOADHISTORY populates the columns of the backupmediaset table with the appropriate values from the media-set header.

-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]

Ken Jr. SSCommitted Points: 1842 More actions · Answer 3

The typical file extensions are:

Full Database Backup - *.bak

Transaction Log Backup - *.trn

Differential Backup - *.dif

Filegroup Backup - *.fil

Tara-1044200 SSCoach Points: 15951 More actions · Answer 4

actually i am looking in to a old bak file from tape and more over all our backup files are saved as .bak files.

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 5

Run restore headeronly from disk='backupfilenamewithpath' and chk column named 'backup type' in output.

Backup type:

1 = Database

2 = Transaction Log

4 = File

5 = Differential

Database

6 = Differential File

MJ