Getting posts from backup

Hey fellows ,
I had an error in one of my blogs that forced me to build it up from scratch.But i realy need to repost the same posts that had been made from users.I have some backups and i would like to find out if it posible to get the posts back from the backup,then create a new directory within the blog and start reposting them through an autoblog posting software.Does anyone knows if this will work?

Thanks in advance.