Unsolved
This post is more than 5 years old
8 Posts
0
721
August 14th, 2014 06:00
Is it possible to restore without XML file or re-create the missing XML file?
Hi,
I have a client using NMM 2.3 with 7.6.3. It was used to backup SQL files. The SqlServerWriter savesets exist but the XML files don't - they've expired. Is there any way to restore data without the missing XML file? Or is there someway to re-create the XML file?
client1 3329061081 05/09/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 3278729436 05/09/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 3228397792 05/09/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 3178066150 05/09/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 3077402861 05/09/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 3060625649 05/09/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full <--- missing xml
client1 2909630769 05/09/2014 01/18/2038 VSS:/ full
client1 2473682261 05/12/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 2440127832 05/12/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 2356241756 05/12/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 2255578466 05/12/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 2205246825 05/12/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 2171692396 05/12/2014 12/31/2014 APPLICATIONS:\SqlServerWriter full
client1 2087806370 05/12/2014 10/30/2014 C:\ProgramData\EMC\NetWorker\LG_VSS_CLIENT12201623247.xml full
Thanks!
crazyrov
4 Operator
•
1.3K Posts
0
August 14th, 2014 07:00
I doubt there being another way to do generate this XML file.
crazyrov
4 Operator
•
1.3K Posts
0
August 14th, 2014 07:00
So what you are trying to say is that you have SQL VSS backup that has expired and you want to make it browse able and get it back.
I believe the XML is required as it contains the meta data related to your database and with out this you wont be able to browse the backed-up SQL data.
Ther_Max
8 Posts
0
August 14th, 2014 07:00
Yes. I need to restore from a SQL VSS backup. The saveset expiry date was changed but unfortunately not for the XML saveset. So the XML saveset has expired and is no longer there.
Is there any way to restore the data without this XML file? I can see the SQL savesets. Or is there some way to re-create the XML file?
bingo.1
2.4K Posts
0
August 14th, 2014 08:00
If the backup media is tape, the save set should still reside on the media as such media cannot be manipulated. It can just be overwritten by re-labeling it.
In this case you sholud be able to scan the tape to retrieve the missing metadata.
Ther_Max
8 Posts
0
August 14th, 2014 08:00
Not tape - disk - DD.
CarlosRojas
1.7K Posts
0
August 14th, 2014 13:00
Hi there,
For SQL backups I don't think it's possible, as the XML files is what is called the BCD (Backup Component Document), in o the words, this is the file that contains all the information for the VSS writer in terms of file location, writer information, snapshot type and status etc.
I'm not aware of an alternate method to do this restore, but I'll double check, as there is a method to restore other data bypassing the VSS internal mechanism (restore the data as flat files), but don't think for SQL this would work.
Thank you,
Carlos