SQL SERVER – 2005 – No Backup Support For Named Pipes

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)

SQL Backup and Restore
Previous Post
SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error
Next Post
SQL SERVER – 2005 – Use Always Outer Join Clause instead of (*= and =*)

Related Posts

4 Comments. Leave new

Leave a Reply