Veritas-bu

Re: [Veritas-bu] SQL Server Database Restore

2008-03-18 07:09:03
Subject: Re: [Veritas-bu] SQL Server Database Restore
From: Justin Piszcz <jpiszcz AT lucidpixels DOT com>
To: Julio Duarte de Assis Dezan <jdezan AT diveo.net DOT br>
Date: Tue, 18 Mar 2008 06:47:32 -0400 (EDT)

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

<Prev in Thread] Current Thread [Next in Thread>