Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to Find Backup type

Author  Topic 

sql2020
Yak Posting Veteran

54 Posts

Posted - 2010-08-13 : 02:52:46
How to find Backuptype in sqlserver.

Ex:

what is fullbackup file what is Differential backup?

sql2020

Kristen
Test

22859 Posts

Posted - 2010-08-13 : 03:03:31
RESTORE HEADERONLY ?
Go to Top of Page

sql2020
Yak Posting Veteran

54 Posts

Posted - 2010-08-13 : 03:16:59
can you explain where exactly?

sql2020
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-08-13 : 03:30:33
http://msdn.microsoft.com/en-us/library/ms178536.aspx
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-17 : 04:17:15
the following tables will provide you with information on the backups

msdb.dbo.backupset --check the description to identify what type of backup is the backupset taken

msdb.dbo.backupfile
msdb.dbo.backupmediafamily
msdb.dbo.backupmediaset

HTH

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -