[Bacula-users] How to Use named pipe device to backup MS SQL Server

[mods]

Hello,

I am newbie for bacula. I want to use named pipe device to backup a MS SQL Server.
I installed the Win32 client 1.29.
In MS SQL Server,I use:
1> backup database master to PIPE='\\.\pipe\pipetest'
2> go
In bacula-dir.conf,I don't known how to add '\\.\pipe\pipetest' to FileSet.
Now my FileSet in bacula-dir.conf is:
FileSet {
Name = "Full Set FIFO"
Include = signature=MD5 readfifo=yes {
"\\./pipe/pipe1"
}
Exclude = { }
}
But bacula-dir can't find "\\./pipe/pipe1",Its messages is:
23-Apr-2003 03:24 bacula-dir: Could not stat \./pipe/pipe1: ERR=No such file or directory



I need your advice.


Best regards,

deshou

[Jari Fredriksson]

Post by mods
But bacula-dir can't find "\\./pipe/pipe1",Its
23-Apr-2003 03:24 bacula-dir: Could not
stat \./pipe/pipe1: ERR=No such file or directory
I need your advice.
Best regards,
deshou

The answer is in the error message: \./pipe/pipe1

You should try //./pipe/pipetest

or \\\\./pipe/pipetest

Two backslashes are converted to one, so use four for 2, or two forward
slashes.

Hopefully helps.

Rgds, jarif

[mods]

Hello,
thank you for your very quick answer!

Now my FileSet in bacula-dir.conf is:
FileSet {
Name = "Full Set FIFO"
Include = signature=MD5 readfifo=yes {
"\\\\./pipe/pipetest"
}
Exclude = { }
}
But console error messages is:
23-Apr-2003 06:31 bacula-fd: attribs.c:396 Error in GetFileAttributesEx: file \\.\pipe\pipetest: ERR=All pipe instances are busy.

JobId: 29
Job: NightlySaveFIFO.2003-04-23_06.31.41
FileSet: Full Set FIFO
Backup Level: Full
Client: bacula-fd
Start time: 23-Apr-2003 06:31
End time: 23-Apr-2003 06:31
Files Written: 1
Bytes Written: 55
Rate: 0.1 KB/s
Software Compression: None
Volume names(s): test001
Volume Session Id: 6
Volume Session Time: 1051067202
Last Volume Bytes: 10,362,003
FD termination status: OK
SD termination status: OK
Termination: Backup OK


In the SQL Server error log,the error message is:
2003-04-23 14:31:41.66 kernel BackupMedium::ReportIoError: write failure on backup device '\\.\pipe\pipetest'. Operating system error 232(The pipe is being closed. ).

Any idea . Thanks in advance

deshou



----- Original Message -----
From: "Jari Fredriksson" <***@bitwell.com>
To: "bacula-users" <bacula-***@lists.sourceforge.net>
Sent: Wednesday, April 23, 2003 1:01 PM
Subject: Re: [Bacula-users] How to Use named pipe device to backup MS SQL Server

Post by Jari Fredriksson

Post by mods
But bacula-dir can't find "\\./pipe/pipe1",Its
23-Apr-2003 03:24 bacula-dir: Could not
stat \./pipe/pipe1: ERR=No such file or directory
I need your advice.
Best regards,
deshou

The answer is in the error message: \./pipe/pipe1
You should try file://./pipe/pipetest
or \\\\./pipe/pipetest
Two backslashes are converted to one, so use four for 2, or two forward
slashes.
Hopefully helps.
Rgds, jarif
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Bacula-users mailing list
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Kern Sibbald]

Hello,

After thinking about this quite a bit, I can only
guess that even though Windows has pipes (fifos),
Cygwin does not support Unix emulation of fifos. This
is because Bacula is apparently attempting to
backup the pipe rather than read from the pipe.
Most likely it is because Cygwin does not identify
\\.\pipe\pipetest as a fifo.

I'd like to help you, but I'm having more than my
share of problems trying to make Windows file
permissions work, so I won't be able to get to
this any time in the near future.


Best regards,

Kern

Post by mods
Hello,
thank you for your very quick answer!
FileSet {
Name = "Full Set FIFO"
Include = signature=MD5 readfifo=yes {
"\\\\./pipe/pipetest"
}
Exclude = { }
}
23-Apr-2003 06:31 bacula-fd: attribs.c:396 Error in
GetFileAttributesEx: file \\.\pipe\pipetest: ERR=All pipe instances
are busy.
JobId: 29
Job: NightlySaveFIFO.2003-04-23_06.31.41
FileSet: Full Set FIFO
Backup Level: Full
Client: bacula-fd
Start time: 23-Apr-2003 06:31
End time: 23-Apr-2003 06:31
Files Written: 1
Bytes Written: 55
Rate: 0.1 KB/s
Software Compression: None
Volume names(s): test001
Volume Session Id: 6
Volume Session Time: 1051067202
Last Volume Bytes: 10,362,003
FD termination status: OK
SD termination status: OK
Termination: Backup OK
write failure on backup device '\\.\pipe\pipetest'. Operating system
error 232(The pipe is being closed. ).
Any idea . Thanks in advance
deshou
----- Original Message -----
Sent: Wednesday, April 23, 2003 1:01 PM
Subject: Re: [Bacula-users] How to Use named pipe device to backup MS SQL Server

Post by Jari Fredriksson

Post by mods
But bacula-dir can't find "\\./pipe/pipe1",Its
23-Apr-2003 03:24 bacula-dir: Could not
stat \./pipe/pipe1: ERR=No such file or directory
I need your advice.
Best regards,
deshou

The answer is in the error message: \./pipe/pipe1
You should try file://./pipe/pipetest
or \\\\./pipe/pipetest
Two backslashes are converted to one, so use four for 2, or two

forward

Post by Jari Fredriksson
slashes.
Hopefully helps.
Rgds, jarif
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Bacula-users mailing list
https://lists.sourceforge.net/lists/listinfo/bacula-users

[mods]

Try and take that "readfifo=yes" off from the FileSet definition. As fifos
are read like normal files in the "client" side, that should fix the
problem.
Rgds, jarif

Hello,
I had made the "readfifo=yes" off from the FileSet definition and try it.
The pr

[Jari Fredriksson]

Post by mods

Try and take that "readfifo=yes" off from the FileSet definition. As
fifos are read like normal files in the "client" side, that should
fix the problem.
Rgds, jarif

Hello,
I had made the "readfifo=yes" off from the FileSet definition and try
it. The problem are the same.
Thank you.
deshou

In that case, how about backing up the database into a regular file, then
including that file in in bacula fileset? Maybe not as ideal, but should
work.

Regards, jarif


Against TCPA - http://www.againsttcpa.com/index.shtml