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 (http://blog.SQLAuthority.com)

About these ads

5 thoughts on “SQL SERVER – 2005 – No Backup Support For Named Pipes

  1. Pingback: SQL SERVER - 2005 - Use Always Outer Join Clause instead of (*= and =*) Journey to SQL Authority with Pinal Dave

  2. Yeah that was one of a features that had been discontinued in SQL 2005. http://msdn2.microsoft.com/en-us/library/ms144262.aspx That is by design as to comply with new security features introduced in SQL Server 2005. That, however, isn’t as bad as it might seem for the first sight. Named pipes were a demon that often caused problems. Recall the well-known case http://support.microsoft.com/kb/818806 with backup/restore not being disabled after disabling the named pipes protocol. There’s a nice technet article about performing database back up in SQL server 2005 http://msdn2.microsoft.com/en-us/library/ms187510.aspx. It’s also possible to use VSS writer http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlwriter.mspx. Finally how about backing up DB files using something that can retain all file security like Scriptlogic’s Secure Copy? While it’s more of a file server backup and migration tool, I personally got attached to it so that I am now using it for any backup-related operations on my farm as it’s just simple in use and keeps me from worrying about SID security problems. For such a tiny tool I am impressed as it has everything I need. I like when configuring software doesn’t take much time AND and the same very moment the software doesn’t limit YOUR capabilities. This Scriptlogic’s tool is an exception to the rule. Currently it works in my environment with a 24×7 schedule and it’s reporting functionality helps a lot as it allows performing multiple backup operations without any need for intervention from my side. I also like there that it keeps all the security and timestamp information about the files it backs up. There are many positive things I can tell about Secure Copy but it’s far more better to refer to the site page http://www.scriptlogic.com/products/securecopy/ for additional information if needed.
    Personally I liked this http://whitepaper.techweb.com/search/keyword/cmptechweb/SQL%20Server%20Data%20Migration%20White%20Paper/SQL%20Server%20Data%20Migration%20White%20Paper whitepaper about SQL migration.
    Keep working on your blog. I am new to database management and I am glad that I’ve found so much interesting stuff about SQL here. Thank you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s