Restore database from an old backup file and newer transaction logs

[EGNDMR]

Here is the situation:
- My SQL server was not completing its backups due to a lack of hard drive space. (Just found this out)

- My database file is currently 55GB and I have a backup file that is a > year old that is 3GB.

- I have transaction log files that date back 6 months ago.
- Have Differentals dating back 6 months (September 2008)

Question: Can I restore the old backup and apply the differentials and transaction logs to at least get back 6 months of data?

Thanks in advance

-Dean

 

[EGNDMR]

Clarification: MSSQL Server database not My SQL

 

[mutley1]

Short answer - no.

when you take a full backup and the TLOGS / DIFFS afterwards, they are supposed to follow in sequence, i.e. full backup, log1, log2 (or diff1, diff2 etc.) if you have a full backup that is over 1 yr old and logs or diffs for only the last 6 months then your data will not be integral as there will be a portion missing.

HTH,
M.