Re: [Veritas-bu] SQL Server Database Restore
2008-03-18 07:09:03
On Mon, 17 Mar 2008, Julio Duarte de Assis Dezan wrote:
> 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?
Yes, set your fragment size smaller, reduce multiplexing, and make sure
the backup speed is good if possible.
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|