exploring database backup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

exploring database backup

Im 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. ———————–