Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Browse by Tags · View All
sql_server 217
t-sql 211
tsql 116
sqlserver 96
BRH 78
#SQLServer 66
#TSQL 56
SQL Server 34
function 11
SSMS 9

Archive · View All
August 2007 17
August 2010 8
June 2012 7
June 2011 7
November 2007 7
August 2012 6
May 2012 6
November 2011 6
August 2011 6
October 2011 6

Madhivanan's TSQL Blog

Identifying the backup type of backup file

Apr 18 2011 3:06AM by Madhivanan   

Sometimes you may be on need of knowing what the backup type of the backup file is. For example the backup file may be of full backup, transaction log, diffential database etc. If you want to know it before restoring a database you can use RESTORE HEADERONLY option

Assume that you have a backup file test.bak and you want to know the backup type before restoring it

RESTORE HEADERONLY FROM DISK='F:\TEST.BAK'

It will display the all the backup header informations. Now look the column backuptype. Each value belongs to a different backup type

1 = Database 

2 = Transaction log 

4 = File 

5 = Differential database 

6 = Differential file

7 = Partial 

8 = Differential partial

You can find more explanations about this at SQL Server help file under the index RESTORE HEADERONLY statement

Tags: t-sql, sql_server, backup, sqlserver, tsql, BRH, restore,


Madhivanan
3 · 40% · 12936
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]