While helping one of my DBA friend (who works in big company in LA) to upgrade SQL Server 2000 to SQL Server 2005 I just found one thing, which I have not paid attention before.
SQL Server 2000 supported named pipe backup device. SQL Server 2005 does not support named pipe backup device, however SQL Server 2005 supports disk and tape devices.
I receive following question many times, I have answered this question earlier on this blog. I will still answer it again.
What is my preferred method of backup?
We use SAN with RAID 10 configuration. Some industry experts suggested we are overprotecting our database backup. Well, Better safe than sorrow.
Reference : Pinal Dave (https://blog.sqlauthority.com)