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
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
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply