Julio
how long was the backup for this DB
?
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 .....
This email (including any attachments) may contain confidential and/or
privileged information or information otherwise protected from disclosure.
If you are not the intended recipient, please notify the sender
immediately, do not copy this message or any attachments and do not use it
for any purpose or disclose its content to any person, but delete this
message and any attachments from your system. Astrium disclaims any and all
liability if this email transmission was virus corrupted, altered or
falsified.
---------------------------------------------------------------------
Astrium Limited, Registered in England and Wales No. 2449259
REGISTERED OFFICE:-
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
|
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|