Backup to disk

I am setting up my backup strategy and want to do Full backups at night
(12:00 am) and hourly incremental backups to disk.
The problem is the incrementals just keep getting appended to the same data
file *.bak.
If I find that our data is corrupted after about 2:00 pm and want to
restore, I would need to restore the up until 1 PM.
I would need to restore the Full backup and 13 differentials (not all the
differentials).
How do I do that if they are all in the same file?
Thanks,
Tom
You just use the FILE = parameter in your RESTORE command.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
"tshad" <tscheiderich@.ftsolutions.com> wrote in message
news:eohyDNy5FHA.252@.TK2MSFTNGP15.phx.gbl...
>I am setting up my backup strategy and want to do Full backups at night
>(12:00 am) and hourly incremental backups to disk.
> The problem is the incrementals just keep getting appended to the same
> data file *.bak.
> If I find that our data is corrupted after about 2:00 pm and want to
> restore, I would need to restore the up until 1 PM.
> I would need to restore the Full backup and 13 differentials (not all the
> differentials).
> How do I do that if they are all in the same file?
> Thanks,
> Tom
>