Long Running SQL Job

is there any contention while this sp is running as a job?
--
Venkat
sql server admirer
"FreeFish" wrote:

> I've got a SQL SP that when executed in QA takes 5 minutes to run, but whe
n
> scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as
to
> why the difference?Nothing in particular. It would be the same as when I run in QA.
"Venkat" wrote:
[vbcol=seagreen]
> is there any contention while this sp is running as a job?
> --
> Venkat
> sql server admirer
>
> "FreeFish" wrote:
>|||I found it: SET NOCOUNT ON
Found this in a previous post on the same topic.
Thanks -
"FreeFish" wrote:
[vbcol=seagreen]
> Nothing in particular. It would be the same as when I run in QA.
> "Venkat" wrote:
>|||I've got a SQL SP that when executed in QA takes 5 minutes to run, but when
scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as to
why the difference?|||is there any contention while this sp is running as a job?
--
Venkat
sql server admirer
"FreeFish" wrote:

> I've got a SQL SP that when executed in QA takes 5 minutes to run, but whe
n
> scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as
to
> why the difference?|||Nothing in particular. It would be the same as when I run in QA.
"Venkat" wrote:
[vbcol=seagreen]
> is there any contention while this sp is running as a job?
> --
> Venkat
> sql server admirer
>
> "FreeFish" wrote:
>|||I found it: SET NOCOUNT ON
Found this in a previous post on the same topic.
Thanks -
"FreeFish" wrote:
[vbcol=seagreen]
> Nothing in particular. It would be the same as when I run in QA.
> "Venkat" wrote:
>

Long Running SQL Job

I've got a SQL SP that when executed in QA takes 5 minutes to run, but when
scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as to
why the difference?is there any contention while this sp is running as a job?
--
Venkat
sql server admirer
"FreeFish" wrote:
> I've got a SQL SP that when executed in QA takes 5 minutes to run, but when
> scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as to
> why the difference?|||Nothing in particular. It would be the same as when I run in QA.
"Venkat" wrote:
> is there any contention while this sp is running as a job?
> --
> Venkat
> sql server admirer
>
> "FreeFish" wrote:
> > I've got a SQL SP that when executed in QA takes 5 minutes to run, but when
> > scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as to
> > why the difference?|||I found it: SET NOCOUNT ON
Found this in a previous post on the same topic.
Thanks -
"FreeFish" wrote:
> Nothing in particular. It would be the same as when I run in QA.
> "Venkat" wrote:
> > is there any contention while this sp is running as a job?
> > --
> > Venkat
> > sql server admirer
> >
> >
> > "FreeFish" wrote:
> >
> > > I've got a SQL SP that when executed in QA takes 5 minutes to run, but when
> > > scheduled as a Job, takes 35 minutes. Can anyone offer an explanation as to
> > > why the difference?

Long running reports

We have several business areas that want to run a scheduled batch job to
render reports in a pdf file to them. We seem to be hitting an issue with
reports that take longer than 15 minutes to render.
We get the error message, " The underlying connection was closed: Could not
establish secure channel for SSL/TLS" and "An existing connection was
forcibly closed by the remote host"
I have been able to render the reports from the report manager after I set
the default timeout setting to nothing and let the report churn for in some
cases 45 minutes. We have larger volumes of financial data.
Corporately we are looking at setting a timeout standard and having the
report builders create temp tables to report from for the longer running
reports, but more specifiically I am wondering what are all the possible
timeout setting that could be forcing the connection closed? Report
manager? IIS? and has anyone else dealt with this issue and if so how did
you address it?Hello,
I think this issue is caused by IIS timeout settings:
1. Click "Start", and then click "Control Panel".
2. Double-click "Administrative Tools", and then double-click "Internet
Information Services Manager".
3. Expand "Web Sites", right-click "Default Web Site" , and then click
"Properties".
4. Click the "Web Site" tab.
5. In the "Connections" section, in the "Connection timeout" box, increase
the seconds to a value that is sufficient for the length of the import.
Also, please disable Keep-Alives.
6. Click "OK".
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Long running reports
| thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==| X-WBNR-Posting-Host: 64.73.98.126
| From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| Subject: Long running reports
| Date: Tue, 31 May 2005 15:58:11 -0700
| Lines: 18
| Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45040
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We have several business areas that want to run a scheduled batch job to
| render reports in a pdf file to them. We seem to be hitting an issue with
| reports that take longer than 15 minutes to render.
|
| We get the error message, " The underlying connection was closed: Could
not
| establish secure channel for SSL/TLS" and "An existing connection was
| forcibly closed by the remote host"
|
| I have been able to render the reports from the report manager after I
set
| the default timeout setting to nothing and let the report churn for in
some
| cases 45 minutes. We have larger volumes of financial data.
|
| Corporately we are looking at setting a timeout standard and having the
| report builders create temp tables to report from for the longer running
| reports, but more specifiically I am wondering what are all the possible
| timeout setting that could be forcing the connection closed? Report
| manager? IIS? and has anyone else dealt with this issue and if so how
did
| you address it?
||||Peter,
Some more information on the specific error and what we have tried. We have
bumped up the timeout settings for the report manager, the IIS settings on
the developers local maching and disabled keep alives. Are their any more
areas where we could be hitting a timeout parameter. While I wait for your
response I will discuss this further with our server team and SQL dba's for
their suggestions.
here is the actual error log.
******************************************************
I increased the Individual timeout for the report to 1800 seconds and the
IIS settings on my local machine, but the report is still timing out.
with KeepAlive enabled or disabled...
----
*****Creating Report GainsChartReport_CM dan.rhoades@.cunamutual.com
Type=Excel Campaign_Code=C000000010 AC_Product_Code=-1 Contract=-1 *****
Program Started at: 6/1/2005 11:16:35 AM
-- Exception Log Entry --
ENVIRONMENT INFORMATION:
TimeStamp: 6/1/2005 11:32:23 AM
MachineName: WWVXP525563
AppDomainName: RenderReports.exe
ThreadIdentity:
WindowsIdentity: CMUTUAL\cc1854
EXCEPTION INFORMATION:
Exception Type: System.Net.WebException
Status: SecureChannelFailure
Message: The underlying connection was closed: Could
not establish secure channel for SSL/TLS.
TargetSite: System.Net.WebResponse
GetWebResponse(System.Net.WebRequest)
Source: System.Web.Services
Stack Trace:
at
System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
request)
at
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest
request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at RenderReports.ReportingServices.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds)
at RenderReports.Main.RenderEmailLinkReport(String[] strParms, Int32
intReportParameters)
INNER EXCEPTION INFORMATION:
Exception Type: System.IO.IOException
Message: Unable to read data from the transport
connection.
TargetSite: Int32 EndRead(System.IAsyncResult)
Source: System
Stack Trace:
at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
INNER EXCEPTION INFORMATION:
Exception Type: System.IO.IOException
Message: Unable to read data from the transport
connection.
TargetSite: Int32 EndRead(System.IAsyncResult)
Source: System
Stack Trace:
at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
at System.Net.TlsStream.AsyncReceiveComplete(IAsyncResult result)
INNER EXCEPTION INFORMATION:
Exception Type: System.Net.Sockets.SocketException
ErrorCode: 10054
NativeErrorCode: 10054
Message: An existing connection was forcibly closed by
the remote host
TargetSite: Int32 EndReceive(System.IAsyncResult)
Source: System
Stack Trace:
at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
ADDITIONAL INFORMATION:
Error Rendering Report: GainsChartReport_CM
-- Exception Entry End --
**
**
** StartReport = 6/1/2005 11:16:36 AM StopReport = 6/1/2005 11:32:23 AM
** Report GainsChartReport_CM failed after 15 minutes 47 seconds
Program Ended at: 6/1/2005 11:32:25 AM
*----*
*******************************************************
"Peter Yang [MSFT]" wrote:
> Hello,
> I think this issue is caused by IIS timeout settings:
> 1. Click "Start", and then click "Control Panel".
> 2. Double-click "Administrative Tools", and then double-click "Internet
> Information Services Manager".
> 3. Expand "Web Sites", right-click "Default Web Site" , and then click
> "Properties".
> 4. Click the "Web Site" tab.
> 5. In the "Connections" section, in the "Connection timeout" box, increase
> the seconds to a value that is sufficient for the length of the import.
> Also, please disable Keep-Alives.
> 6. Click "OK".
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --
> | Thread-Topic: Long running reports
> | thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==> | X-WBNR-Posting-Host: 64.73.98.126
> | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | Subject: Long running reports
> | Date: Tue, 31 May 2005 15:58:11 -0700
> | Lines: 18
> | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45040
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | We have several business areas that want to run a scheduled batch job to
> | render reports in a pdf file to them. We seem to be hitting an issue with
> | reports that take longer than 15 minutes to render.
> |
> | We get the error message, " The underlying connection was closed: Could
> not
> | establish secure channel for SSL/TLS" and "An existing connection was
> | forcibly closed by the remote host"
> |
> | I have been able to render the reports from the report manager after I
> set
> | the default timeout setting to nothing and let the report churn for in
> some
> | cases 45 minutes. We have larger volumes of financial data.
> |
> | Corporately we are looking at setting a timeout standard and having the
> | report builders create temp tables to report from for the longer running
> | reports, but more specifiically I am wondering what are all the possible
> | timeout setting that could be forcing the connection closed? Report
> | manager? IIS? and has anyone else dealt with this issue and if so how
> did
> | you address it?
> |
>|||Hello,
You may also want to check if you encounter the following known issue
884537 FIX: You may receive a "System.Net.WebException" error message when
you
http://support.microsoft.com/?id=884537
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Long running reports
| thread-index: AcVmykgAseOX2lghQwamF3cLJGlxpw==| X-WBNR-Posting-Host: 64.73.98.126
| From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| References: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
<xDIz1QoZFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: Long running reports
| Date: Wed, 1 Jun 2005 09:52:22 -0700
| Lines: 186
| Message-ID: <DB60FC6A-4119-4C9A-948C-BBE8500DA360@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45109
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
|
| Some more information on the specific error and what we have tried. We
have
| bumped up the timeout settings for the report manager, the IIS settings
on
| the developers local maching and disabled keep alives. Are their any
more
| areas where we could be hitting a timeout parameter. While I wait for
your
| response I will discuss this further with our server team and SQL dba's
for
| their suggestions.
|
| here is the actual error log.
| ******************************************************
| I increased the Individual timeout for the report to 1800 seconds and the
| IIS settings on my local machine, but the report is still timing out.
|
| with KeepAlive enabled or disabled...
|
|
----
--
| *****Creating Report GainsChartReport_CM dan.rhoades@.cunamutual.com
| Type=Excel Campaign_Code=C000000010 AC_Product_Code=-1 Contract=-1 *****
| Program Started at: 6/1/2005 11:16:35 AM
|
|
| -- Exception Log Entry --
| ENVIRONMENT INFORMATION:
| TimeStamp: 6/1/2005 11:32:23 AM
| MachineName: WWVXP525563
| AppDomainName: RenderReports.exe
| ThreadIdentity:
| WindowsIdentity: CMUTUAL\cc1854
|
| EXCEPTION INFORMATION:
| Exception Type: System.Net.WebException
| Status: SecureChannelFailure
| Message: The underlying connection was closed:
Could
| not establish secure channel for SSL/TLS.
| TargetSite: System.Net.WebResponse
| GetWebResponse(System.Net.WebRequest)
| Source: System.Web.Services
| Stack Trace:
| at
| System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
| request)
| at
|
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebReques
t
| request)
| at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
| methodName, Object[] parameters)
| at RenderReports.ReportingServices.ReportingService.Render(String
Report,
| String Format, String HistoryID, String DeviceInfo, ParameterValue[]
| Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
| String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
| Warning[]& Warnings, String[]& StreamIds)
| at RenderReports.Main.RenderEmailLinkReport(String[] strParms, Int32
| intReportParameters)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.IO.IOException
| Message: Unable to read data from the transport
| connection.
| TargetSite: Int32 EndRead(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
| at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.IO.IOException
| Message: Unable to read data from the transport
| connection.
| TargetSite: Int32 EndRead(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
| at System.Net.TlsStream.AsyncReceiveComplete(IAsyncResult result)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.Net.Sockets.SocketException
| ErrorCode: 10054
| NativeErrorCode: 10054
| Message: An existing connection was forcibly closed
by
| the remote host
| TargetSite: Int32 EndReceive(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
| at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
|
| ADDITIONAL INFORMATION:
| Error Rendering Report: GainsChartReport_CM
|
| -- Exception Entry End --
| **
| **
| ** StartReport = 6/1/2005 11:16:36 AM StopReport = 6/1/2005 11:32:23 AM
| ** Report GainsChartReport_CM failed after 15 minutes 47 seconds
| Program Ended at: 6/1/2005 11:32:25 AM
|
*----
*
| *******************************************************
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello,
| >
| > I think this issue is caused by IIS timeout settings:
| >
| > 1. Click "Start", and then click "Control Panel".
| >
| > 2. Double-click "Administrative Tools", and then double-click "Internet
| > Information Services Manager".
| >
| > 3. Expand "Web Sites", right-click "Default Web Site" , and then click
| > "Properties".
| >
| > 4. Click the "Web Site" tab.
| >
| > 5. In the "Connections" section, in the "Connection timeout" box,
increase
| > the seconds to a value that is sufficient for the length of the import.
| > Also, please disable Keep-Alives.
| >
| > 6. Click "OK".
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > =====================================================| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >
| >
| > --
| > | Thread-Topic: Long running reports
| > | thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==| > | X-WBNR-Posting-Host: 64.73.98.126
| > | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| > | Subject: Long running reports
| > | Date: Tue, 31 May 2005 15:58:11 -0700
| > | Lines: 18
| > | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:45040
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | We have several business areas that want to run a scheduled batch job
to
| > | render reports in a pdf file to them. We seem to be hitting an issue
with
| > | reports that take longer than 15 minutes to render.
| > |
| > | We get the error message, " The underlying connection was closed:
Could
| > not
| > | establish secure channel for SSL/TLS" and "An existing connection was
| > | forcibly closed by the remote host"
| > |
| > | I have been able to render the reports from the report manager after
I
| > set
| > | the default timeout setting to nothing and let the report churn for
in
| > some
| > | cases 45 minutes. We have larger volumes of financial data.
| > |
| > | Corporately we are looking at setting a timeout standard and having
the
| > | report builders create temp tables to report from for the longer
running
| > | reports, but more specifiically I am wondering what are all the
possible
| > | timeout setting that could be forcing the connection closed? Report
| > | manager? IIS? and has anyone else dealt with this issue and if so
how
| > did
| > | you address it?
| > |
| >
| >
||||Thanks Peter,
I will follow up with our VS. net product manager to find out what service
packs we have deployed.
"Peter Yang [MSFT]" wrote:
> Hello,
> You may also want to check if you encounter the following known issue
> 884537 FIX: You may receive a "System.Net.WebException" error message when
> you
> http://support.microsoft.com/?id=884537
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --
> | Thread-Topic: Long running reports
> | thread-index: AcVmykgAseOX2lghQwamF3cLJGlxpw==> | X-WBNR-Posting-Host: 64.73.98.126
> | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | References: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
> <xDIz1QoZFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> | Subject: RE: Long running reports
> | Date: Wed, 1 Jun 2005 09:52:22 -0700
> | Lines: 186
> | Message-ID: <DB60FC6A-4119-4C9A-948C-BBE8500DA360@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45109
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | Some more information on the specific error and what we have tried. We
> have
> | bumped up the timeout settings for the report manager, the IIS settings
> on
> | the developers local maching and disabled keep alives. Are their any
> more
> | areas where we could be hitting a timeout parameter. While I wait for
> your
> | response I will discuss this further with our server team and SQL dba's
> for
> | their suggestions.
> |
> | here is the actual error log.
> | ******************************************************
> | I increased the Individual timeout for the report to 1800 seconds and the
> | IIS settings on my local machine, but the report is still timing out.
> |
> | with KeepAlive enabled or disabled...
> |
> |
> ----
> --
> | *****Creating Report GainsChartReport_CM dan.rhoades@.cunamutual.com
> | Type=Excel Campaign_Code=C000000010 AC_Product_Code=-1 Contract=-1 *****
> | Program Started at: 6/1/2005 11:16:35 AM
> |
> |
> | -- Exception Log Entry --
> | ENVIRONMENT INFORMATION:
> | TimeStamp: 6/1/2005 11:32:23 AM
> | MachineName: WWVXP525563
> | AppDomainName: RenderReports.exe
> | ThreadIdentity:
> | WindowsIdentity: CMUTUAL\cc1854
> |
> | EXCEPTION INFORMATION:
> | Exception Type: System.Net.WebException
> | Status: SecureChannelFailure
> | Message: The underlying connection was closed:
> Could
> | not establish secure channel for SSL/TLS.
> | TargetSite: System.Net.WebResponse
> | GetWebResponse(System.Net.WebRequest)
> | Source: System.Web.Services
> | Stack Trace:
> | at
> | System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
> | request)
> | at
> |
> System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebReques
> t
> | request)
> | at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> | methodName, Object[] parameters)
> | at RenderReports.ReportingServices.ReportingService.Render(String
> Report,
> | String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> | Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> | String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> | Warning[]& Warnings, String[]& StreamIds)
> | at RenderReports.Main.RenderEmailLinkReport(String[] strParms, Int32
> | intReportParameters)
> |
> | INNER EXCEPTION INFORMATION:
> | Exception Type: System.IO.IOException
> | Message: Unable to read data from the transport
> | connection.
> | TargetSite: Int32 EndRead(System.IAsyncResult)
> | Source: System
> | Stack Trace:
> | at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
> | at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
> |
> | INNER EXCEPTION INFORMATION:
> | Exception Type: System.IO.IOException
> | Message: Unable to read data from the transport
> | connection.
> | TargetSite: Int32 EndRead(System.IAsyncResult)
> | Source: System
> | Stack Trace:
> | at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
> | at System.Net.TlsStream.AsyncReceiveComplete(IAsyncResult result)
> |
> | INNER EXCEPTION INFORMATION:
> | Exception Type: System.Net.Sockets.SocketException
> | ErrorCode: 10054
> | NativeErrorCode: 10054
> | Message: An existing connection was forcibly closed
> by
> | the remote host
> | TargetSite: Int32 EndReceive(System.IAsyncResult)
> | Source: System
> | Stack Trace:
> | at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
> | at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
> |
> | ADDITIONAL INFORMATION:
> | Error Rendering Report: GainsChartReport_CM
> |
> | -- Exception Entry End --
> | **
> | **
> | ** StartReport = 6/1/2005 11:16:36 AM StopReport = 6/1/2005 11:32:23 AM
> | ** Report GainsChartReport_CM failed after 15 minutes 47 seconds
> | Program Ended at: 6/1/2005 11:32:25 AM
> |
> *----
> *
> | *******************************************************
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello,
> | >
> | > I think this issue is caused by IIS timeout settings:
> | >
> | > 1. Click "Start", and then click "Control Panel".
> | >
> | > 2. Double-click "Administrative Tools", and then double-click "Internet
> | > Information Services Manager".
> | >
> | > 3. Expand "Web Sites", right-click "Default Web Site" , and then click
> | > "Properties".
> | >
> | > 4. Click the "Web Site" tab.
> | >
> | > 5. In the "Connections" section, in the "Connection timeout" box,
> increase
> | > the seconds to a value that is sufficient for the length of the import.
> | > Also, please disable Keep-Alives.
> | >
> | > 6. Click "OK".
> | >
> | > Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > When responding to posts, please "Reply to Group" via your newsreader
> so
> | > that others may learn and benefit from your issue.
> | >
> | > =====================================================> | >
> | > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> | >
> | >
> | >
> | >
> | > --
> | > | Thread-Topic: Long running reports
> | > | thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==> | > | X-WBNR-Posting-Host: 64.73.98.126
> | > | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | > | Subject: Long running reports
> | > | Date: Tue, 31 May 2005 15:58:11 -0700
> | > | Lines: 18
> | > | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:45040
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | We have several business areas that want to run a scheduled batch job
> to
> | > | render reports in a pdf file to them. We seem to be hitting an issue
> with
> | > | reports that take longer than 15 minutes to render.
> | > |
> | > | We get the error message, " The underlying connection was closed:
> Could
> | > not
> | > | establish secure channel for SSL/TLS" and "An existing connection was
> | > | forcibly closed by the remote host"
> | > |
> | > | I have been able to render the reports from the report manager after
> I
> | > set
> | > | the default timeout setting to nothing and let the report churn for
> in
> | > some
> | > | cases 45 minutes. We have larger volumes of financial data.
> | > |
> | > | Corporately we are looking at setting a timeout standard and having
> the
> | > | report builders create temp tables to report from for the longer
> running
> | > | reports, but more specifiically I am wondering what are all the
> possible
> | > | timeout setting that could be forcing the connection closed? Report
> | > | manager? IIS? and has anyone else dealt with this issue and if so
> how
> | > did
> | > | you address it?
> | > |
> | >
> | >
> |
>sql

long running jobs crashing the box

Ive a got an sql server that crashes whenever a job runs for a minimum of
5 - 10 minutes. It doesnt happen 100% of the time, probably 80-90%. It
doesnt matter if the job is scheduled, run manually, a backup, a reindex, a
data transfer, whatever, if it runs between 5 and 10 minutes, the box
crashes. Of course it happens most frquently during backups as they are run
the most. All ideas are appreicated.
--
SQL2K SP3
TIA, ChrisR"ChrisR" <bla@.noemail.com> wrote in message
news:u%23$pQDT4EHA.936@.TK2MSFTNGP12.phx.gbl...
> Ive a got an sql server that crashes whenever a job runs for a minimum of
> 5 - 10 minutes. It doesnt happen 100% of the time, probably 80-90%. It
> doesnt matter if the job is scheduled, run manually, a backup, a reindex,
> a
> data transfer, whatever, if it runs between 5 and 10 minutes, the box
> crashes. Of course it happens most frquently during backups as they are
> run
> the most. All ideas are appreicated.
> --
> SQL2K SP3
> TIA, ChrisR
>
What do you mean by crashes? Does the O/S die and you get a blue screen?
Does SQL Server stop running, but the O/S is okay?
What version of O/S, what version of SQL Server? What service packs have
you installed.
What are you using for backups? Is it a standard SQL Server backup or are
you using some other program?
More information would be helpful.
Rick Sawtell
MCT, MCSD, MCDBA|||> What do you mean by crashes? Does the O/S die and you get a blue screen?
> Does SQL Server stop running, but the O/S is okay?
Blue screen.
> What version of O/S, what version of SQL Server? What service packs have
> you installed.
Win2K sp4
SQL2K sp3a
> What are you using for backups? Is it a standard SQL Server backup or are
> you using some other program?
Standard SQL.
Let me know if more info is required.
Thanks, ChrisR
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:OZwiGUT4EHA.1452@.TK2MSFTNGP11.phx.gbl...
> "ChrisR" <bla@.noemail.com> wrote in message
> news:u%23$pQDT4EHA.936@.TK2MSFTNGP12.phx.gbl...
> > Ive a got an sql server that crashes whenever a job runs for a minimum
of
> > 5 - 10 minutes. It doesnt happen 100% of the time, probably 80-90%. It
> > doesnt matter if the job is scheduled, run manually, a backup, a
reindex,
> > a
> > data transfer, whatever, if it runs between 5 and 10 minutes, the box
> > crashes. Of course it happens most frquently during backups as they are
> > run
> > the most. All ideas are appreicated.
> >
> > --
> > SQL2K SP3
> >
> > TIA, ChrisR
> >
> >
> What do you mean by crashes? Does the O/S die and you get a blue screen?
> Does SQL Server stop running, but the O/S is okay?
> What version of O/S, what version of SQL Server? What service packs have
> you installed.
> What are you using for backups? Is it a standard SQL Server backup or are
> you using some other program?
> More information would be helpful.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||What does the Application Log say?
Do you have anything else running on that server besides SQL 2k? (Exchange
maybe?).
Have you tried setting a max server memory for SQL Server? Tune it down a
bit and ensure that you leave enough RAM for the O/S.
(EM-> right-click on Server, Properties)
Rick Sawtell
MCT, MCSD, MCDBA|||The Event Viewer just says "the shut down at (time) was unexpected."
I just changed the memory so we'll see if that fixes anything.
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:OPykeeU4EHA.4092@.TK2MSFTNGP14.phx.gbl...
> What does the Application Log say?
> Do you have anything else running on that server besides SQL 2k?
(Exchange
> maybe?).
> Have you tried setting a max server memory for SQL Server? Tune it down a
> bit and ensure that you leave enough RAM for the O/S.
> (EM-> right-click on Server, Properties)
> Rick Sawtell
> MCT, MCSD, MCDBA
>

long running jobs crashing the box

Ive a got an sql server that crashes whenever a job runs for a minimum of
5 - 10 minutes. It doesnt happen 100% of the time, probably 80-90%. It
doesnt matter if the job is scheduled, run manually, a backup, a reindex, a
data transfer, whatever, if it runs between 5 and 10 minutes, the box
crashes. Of course it happens most frquently during backups as they are run
the most. All ideas are appreicated.
SQL2K SP3
TIA, ChrisR
"ChrisR" <bla@.noemail.com> wrote in message
news:u%23$pQDT4EHA.936@.TK2MSFTNGP12.phx.gbl...
> Ive a got an sql server that crashes whenever a job runs for a minimum of
> 5 - 10 minutes. It doesnt happen 100% of the time, probably 80-90%. It
> doesnt matter if the job is scheduled, run manually, a backup, a reindex,
> a
> data transfer, whatever, if it runs between 5 and 10 minutes, the box
> crashes. Of course it happens most frquently during backups as they are
> run
> the most. All ideas are appreicated.
> --
> SQL2K SP3
> TIA, ChrisR
>
What do you mean by crashes? Does the O/S die and you get a blue screen?
Does SQL Server stop running, but the O/S is okay?
What version of O/S, what version of SQL Server? What service packs have
you installed.
What are you using for backups? Is it a standard SQL Server backup or are
you using some other program?
More information would be helpful.
Rick Sawtell
MCT, MCSD, MCDBA
|||> What do you mean by crashes? Does the O/S die and you get a blue screen?
> Does SQL Server stop running, but the O/S is okay?
Blue screen.

> What version of O/S, what version of SQL Server? What service packs have
> you installed.
Win2K sp4
SQL2K sp3a

> What are you using for backups? Is it a standard SQL Server backup or are
> you using some other program?
Standard SQL.
Let me know if more info is required.
Thanks, ChrisR
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:OZwiGUT4EHA.1452@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> "ChrisR" <bla@.noemail.com> wrote in message
> news:u%23$pQDT4EHA.936@.TK2MSFTNGP12.phx.gbl...
of[vbcol=seagreen]
reindex,
> What do you mean by crashes? Does the O/S die and you get a blue screen?
> Does SQL Server stop running, but the O/S is okay?
> What version of O/S, what version of SQL Server? What service packs have
> you installed.
> What are you using for backups? Is it a standard SQL Server backup or are
> you using some other program?
> More information would be helpful.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||What does the Application Log say?
Do you have anything else running on that server besides SQL 2k? (Exchange
maybe?).
Have you tried setting a max server memory for SQL Server? Tune it down a
bit and ensure that you leave enough RAM for the O/S.
(EM-> right-click on Server, Properties)
Rick Sawtell
MCT, MCSD, MCDBA
|||The Event Viewer just says "the shut down at (time) was unexpected."
I just changed the memory so we'll see if that fixes anything.
"Rick Sawtell" <quickening@.msn.com> wrote in message
news:OPykeeU4EHA.4092@.TK2MSFTNGP14.phx.gbl...
> What does the Application Log say?
> Do you have anything else running on that server besides SQL 2k?
(Exchange
> maybe?).
> Have you tried setting a max server memory for SQL Server? Tune it down a
> bit and ensure that you leave enough RAM for the O/S.
> (EM-> right-click on Server, Properties)
> Rick Sawtell
> MCT, MCSD, MCDBA
>
sql

LOGS Files

Hi All,
SQL 2000 sp4 under Windows 2000 server sp4.
I have problem with my logs files, they are growing so much. I have
optimization job schedule once a week but looks like it's no helping with
logs files.
To fix a problem this morning on my server we have to detach the data,
delete the log file and attach the data again to be able to work.
Should I create a script to detach, delete the log files and attach the data
again everyday at midnight?
I have a low budget so I can't use third party software
It's a better way to fix this?
Tks in advance.
JFBJFB,
What is your recovery model set to. Is it set to full? if yes I am
assuming this is a production database.
Have you tried using DBCC SHRINKFILE as a nightly job, rather than detaching
and reattaching data everyday.
Thanks,
Rocky A
"JFB" wrote:

> Hi All,
> SQL 2000 sp4 under Windows 2000 server sp4.
> I have problem with my logs files, they are growing so much. I have
> optimization job schedule once a week but looks like it's no helping with
> logs files.
> To fix a problem this morning on my server we have to detach the data,
> delete the log file and attach the data again to be able to work.
> Should I create a script to detach, delete the log files and attach the da
ta
> again everyday at midnight?
> I have a low budget so I can't use third party software
> It's a better way to fix this?
> Tks in advance.
> JFB
>
>|||Run regular transaction log backups to address the issues
with the size of the log files.
-Sue
On Mon, 1 May 2006 17:43:35 -0400, "JFB" <help@.jfb.com>
wrote:

>Hi All,
>SQL 2000 sp4 under Windows 2000 server sp4.
>I have problem with my logs files, they are growing so much. I have
>optimization job schedule once a week but looks like it's no helping with
>logs files.
>To fix a problem this morning on my server we have to detach the data,
>delete the log file and attach the data again to be able to work.
>Should I create a script to detach, delete the log files and attach the dat
a
>again everyday at midnight?
>I have a low budget so I can't use third party software
>It's a better way to fix this?
>Tks in advance.
>JFB
>|||If you not require transaction log backup set recovery model to simple.
else if recovery model is not simple
Take transaction log backup regularaly , it will truncate commited log.
or in critical condition you can use
backup log <dbname> with no_log.
This will truncate log without backup , but its not recommended , since
it will break chain of transaction log.
Dont play with database by detaching backup and deleting log files.
Regards
Amish shah|||Tks for reply.
I have daily log backups as part of my maintenance schedule jobs using this
EXEC msdb..prc_DBMaint_SLSBackup '-PlanID
581A1AC8-129F-4814-BBA3-07B066A49109 -WriteHistory -VrfyBackup -BkUpOnlyIfC
lean
-CkDB -BkUpMedia DISK -BkUpLog "E:\MSSQL\BackupLogs" -DelBkUps
2WEEKS -CrBkSubDir -BkExt "TRN"'
But looks like it's not truncated commited log.
It's a way to include the no_log in this command line?
Rgds
JFB
"amish" <shahamishm@.gmail.com> wrote in message
news:1146568036.357821.223340@.v46g2000cwv.googlegroups.com...
> If you not require transaction log backup set recovery model to simple.
> else if recovery model is not simple
> Take transaction log backup regularaly , it will truncate commited log.
> or in critical condition you can use
> backup log <dbname> with no_log.
> This will truncate log without backup , but its not recommended , since
> it will break chain of transaction log.
> Dont play with database by detaching backup and deleting log files.
> Regards
> Amish shah
>|||Did you verify that transaction log backups are actually
going to the BackupLogs directory?
You may also need to increase the frequency of your log
backups.
With maintenance plans, you don't have as much flexibility
on the various commands. There is no option to do a no_log
or truncate_only through maintenance plans.
-Sue
On Tue, 2 May 2006 10:37:43 -0400, "JFB" <help@.jfb.com>
wrote:

>Tks for reply.
>I have daily log backups as part of my maintenance schedule jobs using this
>EXEC msdb..prc_DBMaint_SLSBackup '-PlanID
>581A1AC8-129F-4814-BBA3-07B066A49109 -WriteHistory -VrfyBackup -BkUpOnlyIf
Clean
> -CkDB -BkUpMedia DISK -BkUpLog "E:\MSSQL\BackupLogs" -DelBkUps
>2WEEKS -CrBkSubDir -BkExt "TRN"'
>But looks like it's not truncated commited log.
>It's a way to include the no_log in this command line?
>Rgds
>JFB
>
>"amish" <shahamishm@.gmail.com> wrote in message
>news:1146568036.357821.223340@.v46g2000cwv.googlegroups.com...
>|||Tks for you reply Sue,
So how can I do it on a store procedure?
Any link or example... I'm going to install probably another HD to my raid
to fix this problem temporaly but I need to cut this logs..
Please help
Rgds
JFB
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:j44i52d1v8ta0lch1tm8od9di8vdsd911t@.
4ax.com...
> Did you verify that transaction log backups are actually
> going to the BackupLogs directory?
> You may also need to increase the frequency of your log
> backups.
> With maintenance plans, you don't have as much flexibility
> on the various commands. There is no option to do a no_log
> or truncate_only through maintenance plans.
> -Sue
> On Tue, 2 May 2006 10:37:43 -0400, "JFB" <help@.jfb.com>
> wrote:
>
>|||The SQL statement would be:
Backup Log YourDB
with truncate_only
-Sue
On Fri, 5 May 2006 21:30:00 -0400, "JFB" <help@.jfb.com>
wrote:

>Tks for you reply Sue,
>So how can I do it on a store procedure?
>Any link or example... I'm going to install probably another HD to my raid
>to fix this problem temporaly but I need to cut this logs..
>Please help
>Rgds
>JFB
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:j44i52d1v8ta0lch1tm8od9di8vdsd911t@.
4ax.com...
>

LOGS Files

Hi All,
SQL 2000 sp4 under windows 2000 server sp4.
I have problem with my logs files, they are growing so much. I have
optimization job schedule once a week but looks like it's no helping with
logs files.
To fix a problem this morning on my server we have to detach the data,
delete the log file and attach the data again to be able to work.
Should I create a script to detach, delete the log files and attach the data
again everyday at midnight?
I have a low budget so I can't use third party software :(
It's a better way to fix this?
Tks in advance.
JFBJFB,
What is your recovery model set to. Is it set to full? if yes I am
assuming this is a production database.
Have you tried using DBCC SHRINKFILE as a nightly job, rather than detaching
and reattaching data everyday.
Thanks,
Rocky A
"JFB" wrote:
> Hi All,
> SQL 2000 sp4 under windows 2000 server sp4.
> I have problem with my logs files, they are growing so much. I have
> optimization job schedule once a week but looks like it's no helping with
> logs files.
> To fix a problem this morning on my server we have to detach the data,
> delete the log file and attach the data again to be able to work.
> Should I create a script to detach, delete the log files and attach the data
> again everyday at midnight?
> I have a low budget so I can't use third party software :(
> It's a better way to fix this?
> Tks in advance.
> JFB
>
>|||Run regular transaction log backups to address the issues
with the size of the log files.
-Sue
On Mon, 1 May 2006 17:43:35 -0400, "JFB" <help@.jfb.com>
wrote:
>Hi All,
>SQL 2000 sp4 under windows 2000 server sp4.
>I have problem with my logs files, they are growing so much. I have
>optimization job schedule once a week but looks like it's no helping with
>logs files.
>To fix a problem this morning on my server we have to detach the data,
>delete the log file and attach the data again to be able to work.
>Should I create a script to detach, delete the log files and attach the data
>again everyday at midnight?
>I have a low budget so I can't use third party software :(
>It's a better way to fix this?
>Tks in advance.
>JFB
>|||If you not require transaction log backup set recovery model to simple.
else if recovery model is not simple
Take transaction log backup regularaly , it will truncate commited log.
or in critical condition you can use
backup log <dbname> with no_log.
This will truncate log without backup , but its not recommended , since
it will break chain of transaction log.
Dont play with database by detaching backup and deleting log files.
Regards
Amish shah|||Tks for reply.
I have daily log backups as part of my maintenance schedule jobs using this
EXEC msdb..prc_DBMaint_SLSBackup '-PlanID
581A1AC8-129F-4814-BBA3-07B066A49109 -WriteHistory -VrfyBackup -BkUpOnlyIfClean
-CkDB -BkUpMedia DISK -BkUpLog "E:\MSSQL\BackupLogs" -DelBkUps
2WEEKS -CrBkSubDir -BkExt "TRN"'
But looks like it's not truncated commited log.
It's a way to include the no_log in this command line?
Rgds
JFB
"amish" <shahamishm@.gmail.com> wrote in message
news:1146568036.357821.223340@.v46g2000cwv.googlegroups.com...
> If you not require transaction log backup set recovery model to simple.
> else if recovery model is not simple
> Take transaction log backup regularaly , it will truncate commited log.
> or in critical condition you can use
> backup log <dbname> with no_log.
> This will truncate log without backup , but its not recommended , since
> it will break chain of transaction log.
> Dont play with database by detaching backup and deleting log files.
> Regards
> Amish shah
>|||Did you verify that transaction log backups are actually
going to the BackupLogs directory?
You may also need to increase the frequency of your log
backups.
With maintenance plans, you don't have as much flexibility
on the various commands. There is no option to do a no_log
or truncate_only through maintenance plans.
-Sue
On Tue, 2 May 2006 10:37:43 -0400, "JFB" <help@.jfb.com>
wrote:
>Tks for reply.
>I have daily log backups as part of my maintenance schedule jobs using this
>EXEC msdb..prc_DBMaint_SLSBackup '-PlanID
>581A1AC8-129F-4814-BBA3-07B066A49109 -WriteHistory -VrfyBackup -BkUpOnlyIfClean
> -CkDB -BkUpMedia DISK -BkUpLog "E:\MSSQL\BackupLogs" -DelBkUps
>2WEEKS -CrBkSubDir -BkExt "TRN"'
>But looks like it's not truncated commited log.
>It's a way to include the no_log in this command line?
>Rgds
>JFB
>
>"amish" <shahamishm@.gmail.com> wrote in message
>news:1146568036.357821.223340@.v46g2000cwv.googlegroups.com...
>> If you not require transaction log backup set recovery model to simple.
>> else if recovery model is not simple
>> Take transaction log backup regularaly , it will truncate commited log.
>> or in critical condition you can use
>> backup log <dbname> with no_log.
>> This will truncate log without backup , but its not recommended , since
>> it will break chain of transaction log.
>> Dont play with database by detaching backup and deleting log files.
>> Regards
>> Amish shah
>|||Tks for you reply Sue,
So how can I do it on a store procedure?
Any link or example... I'm going to install probably another HD to my raid
to fix this problem temporaly but I need to cut this logs..
Please help
Rgds
JFB
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:j44i52d1v8ta0lch1tm8od9di8vdsd911t@.4ax.com...
> Did you verify that transaction log backups are actually
> going to the BackupLogs directory?
> You may also need to increase the frequency of your log
> backups.
> With maintenance plans, you don't have as much flexibility
> on the various commands. There is no option to do a no_log
> or truncate_only through maintenance plans.
> -Sue
> On Tue, 2 May 2006 10:37:43 -0400, "JFB" <help@.jfb.com>
> wrote:
>>Tks for reply.
>>I have daily log backups as part of my maintenance schedule jobs using
>>this
>>EXEC msdb..prc_DBMaint_SLSBackup '-PlanID
>>581A1AC8-129F-4814-BBA3-07B066A49109 -WriteHistory -VrfyBackup -BkUpOnlyIfClean
>> -CkDB -BkUpMedia DISK -BkUpLog "E:\MSSQL\BackupLogs" -DelBkUps
>>2WEEKS -CrBkSubDir -BkExt "TRN"'
>>But looks like it's not truncated commited log.
>>It's a way to include the no_log in this command line?
>>Rgds
>>JFB
>>
>>"amish" <shahamishm@.gmail.com> wrote in message
>>news:1146568036.357821.223340@.v46g2000cwv.googlegroups.com...
>> If you not require transaction log backup set recovery model to simple.
>> else if recovery model is not simple
>> Take transaction log backup regularaly , it will truncate commited log.
>> or in critical condition you can use
>> backup log <dbname> with no_log.
>> This will truncate log without backup , but its not recommended , since
>> it will break chain of transaction log.
>> Dont play with database by detaching backup and deleting log files.
>> Regards
>> Amish shah
>>
>|||The SQL statement would be:
Backup Log YourDB
with truncate_only
-Sue
On Fri, 5 May 2006 21:30:00 -0400, "JFB" <help@.jfb.com>
wrote:
>Tks for you reply Sue,
>So how can I do it on a store procedure?
>Any link or example... I'm going to install probably another HD to my raid
>to fix this problem temporaly but I need to cut this logs..
>Please help
>Rgds
>JFB
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:j44i52d1v8ta0lch1tm8od9di8vdsd911t@.4ax.com...
>> Did you verify that transaction log backups are actually
>> going to the BackupLogs directory?
>> You may also need to increase the frequency of your log
>> backups.
>> With maintenance plans, you don't have as much flexibility
>> on the various commands. There is no option to do a no_log
>> or truncate_only through maintenance plans.
>> -Sue
>> On Tue, 2 May 2006 10:37:43 -0400, "JFB" <help@.jfb.com>
>> wrote:
>>Tks for reply.
>>I have daily log backups as part of my maintenance schedule jobs using
>>this
>>EXEC msdb..prc_DBMaint_SLSBackup '-PlanID
>>581A1AC8-129F-4814-BBA3-07B066A49109 -WriteHistory -VrfyBackup -BkUpOnlyIfClean
>> -CkDB -BkUpMedia DISK -BkUpLog "E:\MSSQL\BackupLogs" -DelBkUps
>>2WEEKS -CrBkSubDir -BkExt "TRN"'
>>But looks like it's not truncated commited log.
>>It's a way to include the no_log in this command line?
>>Rgds
>>JFB
>>
>>"amish" <shahamishm@.gmail.com> wrote in message
>>news:1146568036.357821.223340@.v46g2000cwv.googlegroups.com...
>> If you not require transaction log backup set recovery model to simple.
>> else if recovery model is not simple
>> Take transaction log backup regularaly , it will truncate commited log.
>> or in critical condition you can use
>> backup log <dbname> with no_log.
>> This will truncate log without backup , but its not recommended , since
>> it will break chain of transaction log.
>> Dont play with database by detaching backup and deleting log files.
>> Regards
>> Amish shah
>>
>sql

LogReader SubSystem

I'm trying to setup a publisher on an msde database and am getting an error
when running my script. The error in the event viewer (and job history)
is -
Step 2 of job 'machine\instance-database-1' cannot be run because the
LogReader subsystem failed to load. The job has been suspended.
The job category is REPL -LogReader. Any ideas what I can do or what I
missed?
TIA,
Dave
on your msde server open a command prompt and go to c:\program
files\Microsoft sql server\80\com and type logread
do you get an error message?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Dave" <dave.golightly@.stgutah.com> wrote in message
news:uZYCJIYpEHA.2304@.TK2MSFTNGP14.phx.gbl...
> I'm trying to setup a publisher on an msde database and am getting an
error
> when running my script. The error in the event viewer (and job history)
> is -
> Step 2 of job 'machine\instance-database-1' cannot be run because the
> LogReader subsystem failed to load. The job has been suspended.
> The job category is REPL -LogReader. Any ideas what I can do or what I
> missed?
> TIA,
> Dave
>
|||I got -
"'logread' is not recognized as an internal or external command, operable
program or batch file"
So the installshield object I'm using to install the msde isn't installing
the logread file. Is there any other files I should be checking for?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uhmT8OZpEHA.744@.TK2MSFTNGP10.phx.gbl...
> on your msde server open a command prompt and go to c:\program
> files\Microsoft sql server\80\com and type logread
> do you get an error message?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Dave" <dave.golightly@.stgutah.com> wrote in message
> news:uZYCJIYpEHA.2304@.TK2MSFTNGP14.phx.gbl...
> error
>
|||Oops, I'm making a huge mistake here. MSDE servers are not enable to be
transactional publishers. You will have to make it a merge publisher.
Sorry about that.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Dave" <dave.golightly@.stgutah.com> wrote in message
news:Os127ZZpEHA.3688@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> I got -
> "'logread' is not recognized as an internal or external command, operable
> program or batch file"
> So the installshield object I'm using to install the msde isn't installing
> the logread file. Is there any other files I should be checking for?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uhmT8OZpEHA.744@.TK2MSFTNGP10.phx.gbl...
history)
>
|||I'm trying to create a snapshot publisher. Is there a setting I've got
wrong?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eG0FwfZpEHA.592@.TK2MSFTNGP11.phx.gbl...
> Oops, I'm making a huge mistake here. MSDE servers are not enable to be
> transactional publishers. You will have to make it a merge publisher.
> Sorry about that.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Dave" <dave.golightly@.stgutah.com> wrote in message
> news:Os127ZZpEHA.3688@.TK2MSFTNGP09.phx.gbl...
> history)
>
|||Here's the script -
-- Adding the snapshot publication
exec sp_addpublication @.publication = N'inspPro Snapshot Publication',
@.restricted = N'false', @.sync_method = N'native', @.repl_freq = N'snapshot',
@.description = N'Snapshot publication of inspPro database from Publisher
[workstation]\INSPPRO.', @.status = N'active', @.allow_push = N'true',
@.allow_pull = N'true', @.allow_anonymous = N'true', @.enabled_for_internet =
N'false', @.independent_agent = N'true', @.immediate_sync = N'true',
@.allow_sync_tran = N'false', @.autogen_sync_procs = N'true', @.retention = 0,
@.allow_queued_tran = N'true', @.snapshot_in_defaultfolder = N'true',
@.compress_snapshot = N'false', @.ftp_port = 21, @.ftp_login = N'anonymous',
@.allow_dts = N'false', @.allow_subscription_copy = N'false', @.conflict_policy
= N'sub reinit', @.centralized_conflicts = N'true', @.conflict_retention = 14,
@.queue_type = N'sql', @.add_to_active_directory = N'false',
@.logreader_job_name = N'[workstation]\INSPPRO-inspPro-1'
GO
exec sp_addpublication_snapshot @.publication = N'inspPro Snapshot
Publication',@.frequency_type = 4, @.frequency_interval = 1,
@.frequency_relative_interval = 1, @.frequency_recurrence_factor = 0,
@.frequency_subday = 8, @.frequency_subday_interval = 1, @.active_start_date =
0, @.active_end_date = 0, @.active_start_time_of_day = 0,
@.active_end_time_of_day = 235959, @.snapshot_job_name = N'inspPro Snapshot
Snapshot Agent'
GO
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eG0FwfZpEHA.592@.TK2MSFTNGP11.phx.gbl...
> Oops, I'm making a huge mistake here. MSDE servers are not enable to be
> transactional publishers. You will have to make it a merge publisher.
> Sorry about that.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Dave" <dave.golightly@.stgutah.com> wrote in message
> news:Os127ZZpEHA.3688@.TK2MSFTNGP09.phx.gbl...
> history)
>
|||This looks like a updateable subscription using the queue reader. I don't
believe this is supported on MSDE where MSDE is the publisher.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Dave" <dave.golightly@.stgutah.com> wrote in message
news:e0W6CpZpEHA.3868@.TK2MSFTNGP15.phx.gbl...
> Here's the script -
> -- Adding the snapshot publication
> exec sp_addpublication @.publication = N'inspPro Snapshot Publication',
> @.restricted = N'false', @.sync_method = N'native', @.repl_freq =
N'snapshot',
> @.description = N'Snapshot publication of inspPro database from Publisher
> [workstation]\INSPPRO.', @.status = N'active', @.allow_push = N'true',
> @.allow_pull = N'true', @.allow_anonymous = N'true', @.enabled_for_internet =
> N'false', @.independent_agent = N'true', @.immediate_sync = N'true',
> @.allow_sync_tran = N'false', @.autogen_sync_procs = N'true', @.retention =
0,
> @.allow_queued_tran = N'true', @.snapshot_in_defaultfolder = N'true',
> @.compress_snapshot = N'false', @.ftp_port = 21, @.ftp_login = N'anonymous',
> @.allow_dts = N'false', @.allow_subscription_copy = N'false',
@.conflict_policy
> = N'sub reinit', @.centralized_conflicts = N'true', @.conflict_retention =
14,
> @.queue_type = N'sql', @.add_to_active_directory = N'false',
> @.logreader_job_name = N'[workstation]\INSPPRO-inspPro-1'
> GO
> exec sp_addpublication_snapshot @.publication = N'inspPro Snapshot
> Publication',@.frequency_type = 4, @.frequency_interval = 1,
> @.frequency_relative_interval = 1, @.frequency_recurrence_factor = 0,
> @.frequency_subday = 8, @.frequency_subday_interval = 1, @.active_start_date
=[vbcol=seagreen]
> 0, @.active_end_date = 0, @.active_start_time_of_day = 0,
> @.active_end_time_of_day = 235959, @.snapshot_job_name = N'inspPro Snapshot
> Snapshot Agent'
> GO
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eG0FwfZpEHA.592@.TK2MSFTNGP11.phx.gbl...
operable[vbcol=seagreen]
an[vbcol=seagreen]
the[vbcol=seagreen]
what
>

Login Times

Yes there is.
Have a couple of jobs running.
Start the job at a specific time
In the first job put in EXEC sp_denylogin '<usr_name>'
Then if you need to kill any of the processes for that
user still in there.
in the second login put EXEC sp_grantlogin '<usr_name>'.
So you start the first job at say 7pm
And the second job at say 8.30am
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly."
Winston Churchill

>--Original Message--
>Helo,
>Is there any way I could grant or deny a user login based
on the time of
>day?
>I'm running mad with this issue, since not everybody is a
full time
>employee, and for security reasons I would want to block
their logins when
>they are supposed to be out of the office.
>Thanks in advance.
>
>.
>Thanks!
I wasn't thinking about jobs at all... I was running mad trying to pull in
triggers, and even thinking about changing the network configuration... but
my head wasn't thinking on jobs at all and it's a really nice answer.
Thank you Peter.
"Peter The Spate" <anonymous@.discussions.microsoft.com> escribi en el
mensaje news:19dd01c4bb6a$f99c8b10$a301280a@.phx.gbl...[vbcol=seagreen]
> Yes there is.
> Have a couple of jobs running.
> Start the job at a specific time
> In the first job put in EXEC sp_denylogin '<usr_name>'
> Then if you need to kill any of the processes for that
> user still in there.
> in the second login put EXEC sp_grantlogin '<usr_name>'.
> So you start the first job at say 7pm
> And the second job at say 8.30am
> Peter
> "I may be drunk, Miss, but in the morning I will be sober
> and you will still be ugly."
> Winston Churchill
>
> on the time of
> full time
> their logins when