July 18, 2002 at 9:57 am
Maybe someone can help here. I have a backup that runs in 20 minutes or in 5 hours. The difference between 20 minutes and 5 hours occurs when I physically delete the file file for the backup device(on disk). If the file is deleted before the backup, then the backup takes twenty minutes. If I leave the file w/ the previous backup in the file and INIT, then it takes 5 hours. Here is the command I am using to backup the database..
BACKUP DATABASE [i3_eic] TO [i3_eic_Full_01] WITH INIT ,
NOUNLOAD ,
NAME = N'gf_bu_i3_eic_Full',
NOSKIP ,
STATS = 10,
NOFORMAT
Any suggestions???
Thanks..
Jeff
"Keep Your Stick On the Ice" ..Red Green
July 18, 2002 at 10:01 am
That's a strange one. My guess is that it is rewriting the file for some reason before the backup.
Don't use INIT, try to ensure that each backup file has it's own unique name.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply