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)
Discontinued Database Engine Functionality in SQL Server 2005!!
Hi Pinal ,
Lots of other things you will found regarding disscontinued feaature and their replacemnet .
check this link http://msdn2.microsoft.com/en-us/library/ms144262.aspx
Thanks & regards
Praveen barath
[...] 27th, 2007 by pinaldave Yesterday I wrote about how SQL Server 2005 does not support named pipes. Today, my friend called me asking some of his query does not work. I asked him to send me the [...]
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.
Peter,
Thank you, your comment contains information worth one wonderful article.
Regards,
Pinal Dave ( http://www.SQLAuthority.com )
Thanks for the article. It is helpful for me.