February 21, 2006 at 7:12 am
HI All,
I do a full backup weekly on Friday and then I do differential backup on other days. I also do log backup every hour. The differential backup are always overwritten ( they are copied every night to tape )
Here's the problem I lost my monday file and cannot recreate it in the proper format.
BACKUP DATABASE [My DB] TO DISK = [A file path]\[My DB][Day of week].bak WITH INIT , NOUNLOAD , DIFFERENTIAL , NAME = N'DB Backup Job for DB Diff daily', NOSKIP , STATS = 10, NOFORMAT
The script is what I use to create the differential backup. I have substituted the real name with []. I was wondering If on monday during the day, I created a diff backup manualy if it would create a diff file that would get overwrtitten at night? Also would I brake the back up set ?
Thanks
February 22, 2006 at 6:21 am
Since you are appending only the day of the week, yes, the file will be overwritten each time it is run on the same day.
Will you break the back up set - no. Differential backups are cumulative so all the data that was in the first backup will be in the second backup plus any new data that was added since the first backup.
If you need to recover to some point on Monday, restore the Friday full backup, restore the Sunday differential and then play back the log backups up to the point that you to recover.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
February 22, 2006 at 6:32 am
Thank you I needed to confirm with someone.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply