July 18, 2002 at 9:47 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:14 am
Pls don't cross post. All forums are checked by many people (using Active Threads at the top). We see all these posts.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply