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.
Author |
Topic |
dbasandhya
Starting Member
1 Post |
Posted - 2011-03-16 : 10:22:37
|
iam new in sql server . i have backup file. there is no extension how to i know which type that backup |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2011-03-16 : 10:25:47
|
you can find the backup ty with headerinfoonly commandrestore headeronly from disk='your backup file path'in the output, if the backup type is 1, then it is full backup.(and 2 for diff backup 5 for log backup i believe need to recollect)ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-03-16 : 10:30:59
|
quote: Originally posted by sunsanvin you can find the backup ty with headerinfoonly commandrestore headerinfoonly from disk='your backup file path'in the output, if the backup type is 1, then it is full backup.(and 2 for diff backup 5 for log backup i believe need to recollect)ArnavEven you learn 1%, Learn it with 100% confidence.
I think it is RESTORE HEADERONLYMadhivananFailing to plan is Planning to fail |
 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2011-03-16 : 10:58:43
|
you are right Madhi.....ArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
|
|