SQL DB backup named pipes or TCP/IP?

[ekmino]

I am running ARcserve 2000 on Windows 2k service pack 2. I have several MSSQL 2000 databases to backup with the ARCserve SQL agent installed. Can anyone tell me if the perfered agent configuration is to use named pipes or TCP/IP and what the difference between the two is.

 

[speshalyst]

HI,

If it is a remote backup of the SQL databases... use TCP/Ip..

however, trying both TCP/IP and named pipies should not be a problem...

use whatever works best in your environment...

cheers
speshalyst So it Shall be Written!
So it Shall be Done!!

 

[ACiDelic]

TCP/IP is preferred over named pipes. The TCP/IP configuration uses VDI to backup SQL Server, which is faster and uses less resources than named pipes. Local backups are always done using VDI directly.