Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

I have a bunch of .bak files used as a DB dump for SQL server. Each one of them is part of the backup (media set families?). I need to import/restore them. Just to emphasize, the need is load the data from the dump, not to restore a database that was lost etc. I never had that database.

share|improve this question
What you can do with these will differ greatly depending on which version you're using. I believe 2005 and beyond has partial restores. – sam yi Dec 11 '12 at 17:09
2  
Are you asking to somehow read the data in the database backup files w/o actually doing a "restore database"? If so, I'm sure that there are tools out there that do just that, (red-gate.com/products/dba/sql-virtual-restore comes to mind). However, why not just restore the db? – Ben Thul Dec 11 '12 at 18:03
Are there multiple .bak files because one is a full backup, and the others are differential backup files? – James L. Dec 12 '12 at 3:58

migrated from stackoverflow.com Jan 1 at 20:21

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.