Error when running a back up job created n a SQL cluster

Hello,
I'm haveing a strange problem. When I run a backup off the database without
making it a schedule job I get a good backup, when I create it as a job and
run it I receive the folowing error:
[SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
4035). The step failed.
Can anyone help me out on a solution?
may be anything
but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/default...b;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:

> Hello,
> I'm haveing a strange problem. When I run a backup off the database without
> making it a schedule job I get a good backup, when I create it as a job and
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
> 4035). The step failed.
> Can anyone help me out on a solution?

Error when running a back up job created n a SQL cluster

Hello,
I'm haveing a strange problem. When I run a backup off the database without
making it a schedule job I get a good backup, when I create it as a job and
run it I receive the folowing error:
[SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQ
LSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for databa
se
'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Erro
r
4035). The step failed.
Can anyone help me out on a solution?may be anything
but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/defaul...kb;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:

> Hello,
> I'm haveing a strange problem. When I run a backup off the database withou
t
> making it a schedule job I get a good backup, when I create it as a job an
d
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [
;SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for data
base
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Er
ror
> 4035). The step failed.
> Can anyone help me out on a solution?

Error when running a back up job created n a SQL cluster

Hello,
I'm haveing a strange problem. When I run a backup off the database without
making it a schedule job I get a good backup, when I create it as a job and
run it I receive the folowing error:
[SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
4035). The step failed.
Can anyone help me out on a solution?may be anything :)
but try to check security settings for SQL Agent service account and try to
use only tcp/ip...disable named pipes...
also useful link
http://support.microsoft.com/default.aspx?scid=kb;en-us;827452
rgds
Sinisa
"robert_at_cbb" wrote:
> Hello,
> I'm haveing a strange problem. When I run a backup off the database without
> making it a schedule job I get a good backup, when I create it as a job and
> run it I receive the folowing error:
> [SQLSTATE 01000] (Message 3211) ConnectionRead (WrapperRead()). [SQLSTATE
> 01000] (Message 258) General network error. Check your network
> documentation. [SQLSTATE 08S01] (Error 11) Processed 1 pages for database
> 'ExactTMS', file 'PPS_WITH_ISSUED_log' on file 1. [SQLSTATE 01000] (Error
> 4035). The step failed.
> Can anyone help me out on a solution?

error trying to start new maintenenace plan

Hi ,
I am new to sql 2005 and clustering I too have made the same mistake as
wayne see Geoff response on the 5th of Feb. I have a 2 node cluster and I
have installed SQL within the cluster. I just need clafication that I only
need to run the setup and just select integration services no other options
and It will install fine. Do I need to install this on the second node?
Regards
Steve
Try this
How to: Configure Integration Services on a Cluster
http://msdn2.microsoft.com/en-us/library/ms345193.aspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"steve" <smithsls8@.hotmail.com> wrote in message
news:e2Z2dOTWHHA.4624@.TK2MSFTNGP03.phx.gbl...
> Hi ,
> I am new to sql 2005 and clustering I too have made the same mistake as
> wayne see Geoff response on the 5th of Feb. I have a 2 node cluster and I
> have installed SQL within the cluster. I just need clafication that I
> only need to run the setup and just select integration services no other
> options and It will install fine. Do I need to install this on the second
> node?
> Regards
> Steve
>
>

error trying to start new maintance plan

I have a SQL2K5 cluster and I have what I believe is a valid setup but I am
now getting the following error/warning when I try to start the maintenance
wizard or start a new maintenance plan. I have installed workstation tools
on both.
I have Windows 2003 64bit SQL2K5 SP1 with all current patches.
I am new to Clusters as well as SQL2K5 so I may be missing something.
Any guesses?
error message details below.
===================================
The action you attempted to perform on a remote instance of SQL Server has
failed because the action requires a SQL Server component that is not
installed on the remote computer. To proceed, install SQL Server 2005
Management Tools on the remote computer, and then try again. For more
information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server
2005 Books Online, or find the article on MSDN at
http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)
For help, click: http://go.microsoft.com/fwlink/?LinkID=57083
Program Location:
at
Microsoft.SqlServer.Management.DatabaseMaintenance .MaintDesignerMenuHandler.Invoke()
One of the "improvements" for SQL 2005 is that the client tool installer is
not cluster aware. You have to run the installer on each cluster node and
add the client tools. Personally, I do this as a first step before
installing the cluster-aware components rather than as a folllow-on
activity.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:%232fESGxRHHA.3948@.TK2MSFTNGP05.phx.gbl...
>I have a SQL2K5 cluster and I have what I believe is a valid setup but I am
>now getting the following error/warning when I try to start the maintenance
>wizard or start a new maintenance plan. I have installed workstation tools
>on both.
> I have Windows 2003 64bit SQL2K5 SP1 with all current patches.
> I am new to Clusters as well as SQL2K5 so I may be missing something.
> Any guesses?
> error message details below.
> ===================================
> The action you attempted to perform on a remote instance of SQL Server has
> failed because the action requires a SQL Server component that is not
> installed on the remote computer. To proceed, install SQL Server 2005
> Management Tools on the remote computer, and then try again. For more
> information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server
> 2005 Books Online, or find the article on MSDN at
> http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)
> --
> For help, click: http://go.microsoft.com/fwlink/?LinkID=57083
> --
> Program Location:
> at
> Microsoft.SqlServer.Management.DatabaseMaintenance .MaintDesignerMenuHandler.Invoke()
>
>
|||Thanks Geoff, but I have installed on both and now I am wondering if this is
a problem with SP1 as I am getting some hits on google for similar
problems...
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OkyQMMxRHHA.3996@.TK2MSFTNGP04.phx.gbl...
> One of the "improvements" for SQL 2005 is that the client tool installer
> is not cluster aware. You have to run the installer on each cluster node
> and add the client tools. Personally, I do this as a first step before
> installing the cluster-aware components rather than as a folllow-on
> activity.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Wayne" <watkinson@.sd43.bc.ca> wrote in message
> news:%232fESGxRHHA.3948@.TK2MSFTNGP05.phx.gbl...
>
|||Doh, I didn't install Intigration Services! Once I installed them, things
worked as they should.
Error messages were misleading
"Wayne" <watkinson@.sd43.bc.ca> wrote in message
news:e1PGNgxRHHA.3412@.TK2MSFTNGP05.phx.gbl...
> Thanks Geoff, but I have installed on both and now I am wondering if this
> is a problem with SP1 as I am getting some hits on google for similar
> problems...
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OkyQMMxRHHA.3996@.TK2MSFTNGP04.phx.gbl...
>