SQL Server Performance Forum – Threads Archive
exploring database backupIm fairly sure I already know the answer to this, bu its worth asking <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />I have a database backup that I need to retrieve a small table from. However, the backup did not finish and so it about 10% incomplete. Lo and behold, it is now this backup that needs some data recovering from it<br /><br />Are there any tools to interrogate a backup file ? <br /><br />Also purely out of interest, does anyone know how backup files are organised internaly… ie, do they retain their page structure, and ordering of pages? I dont plan to start hex editing the backup <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /> Im just curious about that<br /><br />Thanks
I’m not sure about any 3rd party tools outthere to check consistency of SQL backups, as we can use VERIFYONLY clause in restore to check the backup. I would suggest to refer to Kalen’s Inside SQL Server book for further information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
It might also be interesting to search the sites of software vendors for whitepapers on this topic. ———————–