backup on sql server
Posted on 2011-10-11
hi all, I have a ful backup that runs on a database every night @ 11pm and transactional backups run every 1hr.
suppose if I have to take a full backup @ 9:30am for the database separately (not as part of sql job) and assume I deleted some data from the table in the database @ 10:30am later.
log backup that ran @ 10am, will it backup log from last full which which is @ 9:30am to 10am or from the last log backup which is at 9am to 10am?
In order to do a point in recovery from the backups, which ful backup should I use?
will that 9:30 full backup and 10am log backup is fine?