How to backup database into pipe

• igors-333291

  SSC Enthusiast

  Points: 111

  More actions

  May 30, 2006 at 7:36 am

  #70415

  Hi.

  I have MS SQLServer 2005

  I'm trying to backup database to named pipe.

  I use SQL statement

  BACKUP DATABASE [mydb] TO  DISK = N'\\.\pipe\mytest1' WITH NOFORMAT, NOINIT,  NAME = N'mydb-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

   

  Obviously when I tried to execute this command I received an error

  "Cannot open backup device '\\.\pipe\mytest1'"

  I think this is because the pipe was not created.

  I wrote command line application that creates pipe '\\.\pipe\mytest1'.

  I used CreateNamedPipe() Windows API function

  I executed this command line application and immediately after this executed BACKUP DATABASE SQL statement

  I received another error

  "Cannot open backup device '\\.\pipe\mytest1'. Operating system error 231(All pipe instances are busy.). "

   

  What is the problem?

  May be I opened pipe a wrong way?

  May be problem is in SQL statement?

  Is there another way to backup database into named pipe?

   

  Thanks for advance.

• June 2, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Wayne Fairless

  SSC Veteran

  Points: 220

  More actions

  June 6, 2006 at 1:51 pm

  #642127

  Try it like this.  When connecting to the server, force a Named Pipe connection.  Afterwards, just do you're backup to the drive\path.

  Instead of <servername>

  try

  np:<servername>

  in the Connect To dialog box.