Hi All,
I'm backing up my
SQL servers using Netbackup 5.1 MP6 with SQL
Agent.
It's working fine
but the restores are extremely slow....
Today I started a
160GB DB restore at 01:00 pm and now is 07:00 pm and it is still working in the
restore...
I saw the files
timestamp and there is no activity in the file since 3:40 pm but netbackup is
reading the requested tapes file by file...
Is there is a way to
index the backups to speed up these restores?
Thanks,
Julio
---------------------------------------------------------------------------------
Job
log
3/17/2008 12:58:07 PM - begin Restore 3/17/2008 12:58:08 PM - 1 images
required 3/17/2008 12:58:08 PM - media DB668 required 3/17/2008 12:58:08
PM - media DB854 required 3/17/2008 12:58:08 PM - media DB726
required 3/17/2008 12:58:08 PM - media DB800 required 3/17/2008 12:58:41
PM - restoring image SQLBOB_1202688902 3/17/2008 4:02:22 PM - started process
bptm (17374)
Lots of positioning - looks like it is searching the entire media to track
the backup image
3/17/2008 7:26:49 PM - positioned
DB668; position time: 00:00:00 3/17/2008 7:26:51 PM - positioning DB668 to
file 190 3/17/2008 7:26:51 PM - positioned DB668; position time:
00:00:00 3/17/2008 7:27:05 PM - started process bptm (17374) 3/17/2008
7:27:05 PM - mounting DB854 3/17/2008 7:27:39 PM - mounted; mount time:
00:00:34 3/17/2008 7:27:39 PM - positioning DB854 to file 1 3/17/2008
7:27:39 PM - positioned DB854; position time: 00:00:00 Lots of
positioning -
looks like it is searching the entire media to track the backup
image
3/17/2008 9:24:25 PM - positioned DB854; position
time: 00:00:00 3/17/2008 9:29:42 PM - started process bptm
(17374) 3/17/2008 9:29:42 PM - mounting DB726 .....
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|