Steve Jones - SSC Editor (11/15/2011)
PhilipC (11/14/2011)
What makes you so strongly say not to backup a SQL database across the network out of interest?I've been doing this for a while myself, and found it very reliable in my environment and personally agree a lot with this article.
I have had it fail quite a few times in my career. If there is an issue over the network, then your backup fails, and any time savings are lost, and risk is increased. Perhaps if you have a very reliable network, at a 1Gbps speed, it works very well, but on 100Mbps switches, I've had it fail enough times to not consider it reliable.
I also had problems with it in the early 00s, with SQL 2k and 10-baseT networks. I think the first system I used that allowed reliable network database backups was in 2007, on SQL 2k5, 1 Gbs network, with small databases (none over 10 Gig, if even that).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon