February 10, 2016 at 9:48 am
We are getting an error attempting to restore a backup at a customer site. After much haggling, I finally got the results of RESTORE FILELISTONLY and RESTORE HEADERONLY.
In the first, there is a column named IsPresent, with a value of 0. In BoL, this column says: 1 = The file is present in the backup.
My guess, and my question, is that this is telling me the files don't actually exist in the backup file. I don't recalling seeing this before, and checking a few backups I have taken of databases on my laptop, this value is showing up as 1.
February 10, 2016 at 9:58 am
Yeah, that means that the file(s) with IsPresent=0 can't be restored from that backup. Only time I've seen that is when you do a backup and specify particular files or filegroups for the backup.
Does the BackupTypeDescription in the HEADERONLY results jive with that?
Cheers!
February 10, 2016 at 10:08 am
Jacob Wilkins (2/10/2016)
Yeah, that means that the file(s) with IsPresent=0 can't be restored from that backup. Only time I've seen that is when you do a backup and specify particular files or filegroups for the backup.Does the BackupTypeDescription in the HEADERONLY results jive with that?
Cheers!
The BackupTypeDescription matches the Type in the FILELISTONLY results.
I have told the SysAdmin that brought this issue to my attention that they will need a new backup, and that they should restore that backup as a different database name to test the backup before sending the backup file to the other site to be restored.
February 10, 2016 at 10:16 am
Understood. I was looking more for the full BackupTypeDescription, particularly to see if it was "File or Filegroup". The Type column in RESTORE FILELISTONLY is the type of file each file is, not the type of backup.
At any rate, yeah, likely not much better can be done than taking a new backup.
Cheers!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply