November 21, 2011 at 4:06 pm
Hi ,
Like to know which option should would be better when taking Large DB backup which running for 5 to 7 hrs on shared drive. Append or Overwirte?
wants to keep old backup file untill new backup file created .so we are appending backup now but it creates two file in backup device so how the automated restore process knows which is new one and which is old one?
November 22, 2011 at 1:10 am
Performancewise I don't think there is any difference between append or overwrite. But if you want to automate your restore procedure I would advise to create a separate file for each backup and the delete the old file after the backup has finished.
Furthermore on a if your backup takes that long, have you tried to use more than one backup file? I have several large databases there we use 8 backup files and reduced the backup time from over 4 hours to less than 1 hour. Of course this doesn't make an automatic restore easier but with a little querying of the sysbackup tables you can easily find all the filenames belonging to a certain backup.
[font="Verdana"]Markus Bohse[/font]
November 23, 2011 at 6:20 am
logicinside22 (11/21/2011)
Hi ,it creates two file in backup device so how the automated restore process knows which is new one and which is old one?
Take a look at the syntax for the RESTORE statement, there is a clause
"FILE = " where you can specify which backup file to restore. The first one is FILE = 1, the second is FILE = 2, and so on.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply