In SQL Server 2005, how do you perform a backup using Named Pipes?
A. Normal backups to local disks all use named pipes
B. In the TO part of the backup command, specify the pipe as “TO PIPE = “\sql\pipe”
C. SQL Server 2005 does not support backup to named pipes
D. In the OPTIONS part of backup command, specify the pipe as OPTIONS PIPE
Answer:C
In SQL Server 2005, how do you perform a backup using Named Pipes?
A. Normal backups to local disks all use named pipes B. In the TO part of the backup command, specify the pipe as “TO PIPE = “\sql\pipe” C. SQL Server 2005 does not support backup to named pipes D. In the OPTIONS part of backup command, specify the pipe as OPTIONS PIPE