Is a partial restore of data from backup possible? Apologies if I haven't used the correct terminology, I am not a DBA, but right now, I am all that is here!

Situation is last week, a database server was misbehaving (it was about 6 years old). The hosting company built a new server, and moved all the current data across to the new server, which is running well.

However, somehow, the new server is missing 36 hours of data. The hosting company has provided us with a backup that contains this data, amongst other things.

As some of the tables have auto generated keys (type integer) is there any way of restoring just a set of data from a date range back into my live database? I obviously can't just cut and paste, as all the integrity of the data will be lost.

Thoughts?

Windows Server and Microsoft SQL Server 2008.
No, you cannot do what you mentioned in your question. 

I am sure there are many ways to recover the data you need.  One way is to:


Restore the backup as a different(name) database. 
Reconcile data using this source and your current live database.  How you do that? Will entirely depend upon with what you have lost and your business logic. 
You can surely take advantage of auto generated integer keys (at least for the tables that has this). You might have to do some plumbing here depending on where is the gap in your current live database.


I know it is a very generic answer. If you need specific help with individual tables, you will need to post table schema, sample data and details of gaps.

On a side note you probably want to reconsider using this hosting company going forward.