You are here: Re: Backup Priority level « MsSQL Server « IT news, forums, messages
Re: Backup Priority level

Posted by Greg D. Moore \(Strider\) on 12/20/06 01:17

"gabe101" <gabe101@gmail.com> wrote in message
news:1166551052.960302.151960@80g2000cwy.googlegroups.com...
> Erland Sommarskog wrote:
>
> We have a good server but it's our only server (Dual Xeon 3.0, 4GB RAM
> and 4, 10K RPM RAID-5 drives). Originally, it was just SQL Server and
> Symantec AV...now it's also Exchange. The backup is being stored to
> the Data partition on that same server's RAID drives.

Argh, you're really stressing that machine.

Try backing up over the wire to a UNC share on another machine. You are
almost definitely stressing the disk I/O system on this box.

A backup on the same machine won't do you much good if say the RAID
controller fails.

Also, you may still want to look at transaction log backups, they'll
generally be much smaller and you can do more often w/o impacting
performance nearly as much.


>
> Thanks Erland.
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация