January 15, 2010 at 1:59 pm
I am running restore database filelistonly and need to retrieve logical device names and backup type.
When i use Idera sql safe to get backup file details, it give following information
database_name nvarchar(50),
backup_type nvarchar(30),
FileGroupName nvarchar(128),
LogicalName nvarchar(128) ,
PhysicalName nvarchar(260) ,
aks Differential PRIMARY DBA_Test D:\Data\aks.mdf
aks Differential <null> DBA_Test_log D:\Log\aks_log.ldf
if my backups are native, running restore filelistonly, i can't find out backup_type.
from manual, it says
"For differential backups, changes with log sequence numbers greater than or equal to DifferentialBaseLSN are included in the differential.
For other backup types, the value is NULL. "
but my output for a full or differential backup is exactly same (except for backup size itself).
from diff dump:
DBA_TestD:\Data\aks1_data.mdfDPRIMARY2338324483518437208064010016AE2454-3489-4496-942A-F50615E22569003276805121NULL224900000034080003776EA62CA-FF51-4513-92A7-B448C785D8DA01
DBA_Test_logD:Log\aks1_log.ldfLNULL1153433621990232555522002EC8F024-6BF9-4F26-8F31-908BF83919370005120NULL000000000-0000-0000-0000-00000000000001
from full dump:
DBA_TestD:\Data\aks1_data.mdfDPRIMARY2338324483518437208064010016AE2454-3489-4496-942A-F50615E22569001444413445121NULL224900000034080003776EA62CA-FF51-4513-92A7-B448C785D8DA01
DBA_Test_logD:\Log\aks1_log.ldfLNULL1153433621990232555522002EC8F024-6BF9-4F26-8F31-908BF83919370005120NULL000000000-0000-0000-0000-00000000000001
Any idea how to retrieve the backup type from dump file ( assume i don't have source server access where backup was taken)
thanks
AKS
January 15, 2010 at 2:11 pm
Use RESTORE HEADERONLY, that will tell you what type of backup the native backup file contains.
January 15, 2010 at 3:14 pm
thanks . i see the backup type.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply