peer to peer replication

Hi,

I set up a peer to peer replication on servers, but only one side seem to be working. I am getting Log Reader Agent job error.

Unable to start execution of step 2 (reason: Error authenticating proxy domain\user, system error: Logon failure: unknown user name or bad password.). The step failed.

I am using the same windows account on both servers, why is one side working and the other side not?

thanks

doublecheck the account and password that starts the job, sqlserver and sqlagent service, and doublecheck their permissions on the machine.

PDF rendering error; log file entries included.

I am having a problem getting a report with many charts to export to PDF.
Currently the report contains 52 line charts (possibility for much more than
that)and fails when the subscription is running. If I only choose data that
returns about 10 or less charts than it will successfully create the PDF.
Is there a file size limitation or another setting I am missing in the
configuration?
Begin of log entries.
ReportingServicesService!reportrendering!f54!02/25/2005-20:37:19:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Threading.ThreadAbortException: Thread was being aborted.
at System.Drawing.SafeNativeMethods.GdipDrawImageRectI(HandleRef
graphics, HandleRef image, Int32 x, Int32 y, Int32 width, Int32 height)
at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y, Int32
width, Int32 height)
at System.Drawing.Bitmap..ctor(Image original, Int32 width, Int32 height)
at System.Drawing.Bitmap..ctor(Image original)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.Process32bppArgbImages(CanvasImage
image, StringBuilder streamString, StringBuilder imageContentString, Int64&
streamLength)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImage
image, Double left, Double top, Double width, Double height, Boolean
scaleImage)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects
outlines, CanvasImage image, Double left, Double top, Double width, Double
height)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Chart.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ListContent.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.List.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!runningjobs!f54!02/25/2005-20:37:22:: i INFO:
CancelableJobExecution.Execute caught some other thread abort exception
ReportingServicesService!library!f54!02/25/2005-20:37:22:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!f54!02/25/2005-20:37:24:: Error
sending email. System.Threading.ThreadAbortException: Thread was being
aborted.
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!f54!02/25/2005-20:37:25:: Error thrown
by delivery provider: System.Threading.ThreadAbortException: Thread was being
aborted.
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
ReportingServicesService!notification!f54!02/25/2005-20:37:26:: e ERROR:
Error occured processing notification. Thread was being aborted.
ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27::
NotificationPolling no longer processing item
36b6fea8-ebac-4de7-b5ef-74c792df8276, will be requeued
ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: Queue worker
thread caught unhandled exception: System.Threading.ThreadAbortException:
Thread was being aborted.
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
at
Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
at
Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
state)Sometimes PDF rendering chews up quite a bit of memory. (Yes, there is room
for optimization if future versions :) You're probably hitting the upper
limits of the machine.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff S." <JeffS@.discussions.microsoft.com> wrote in message
news:FF469815-A1B9-4155-9A62-710DA4EFDBC7@.microsoft.com...
>I am having a problem getting a report with many charts to export to PDF.
> Currently the report contains 52 line charts (possibility for much more
> than
> that)and fails when the subscription is running. If I only choose data
> that
> returns about 10 or less charts than it will successfully create the PDF.
> Is there a file size limitation or another setting I am missing in the
> configuration?
>
> Begin of log entries.
> ReportingServicesService!reportrendering!f54!02/25/2005-20:37:19:: e
> ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.Threading.ThreadAbortException: Thread was being
> aborted.
> at System.Drawing.SafeNativeMethods.GdipDrawImageRectI(HandleRef
> graphics, HandleRef image, Int32 x, Int32 y, Int32 width, Int32 height)
> at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y,
> Int32
> width, Int32 height)
> at System.Drawing.Bitmap..ctor(Image original, Int32 width, Int32
> height)
> at System.Drawing.Bitmap..ctor(Image original)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.Process32bppArgbImages(CanvasImage
> image, StringBuilder streamString, StringBuilder imageContentString,
> Int64&
> streamLength)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImage
> image, Double left, Double top, Double width, Double height, Boolean
> scaleImage)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects
> outlines, CanvasImage image, Double left, Double top, Double width, Double
> height)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Chart.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ListContent.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.List.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> Int32 endPage, Boolean render)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
> A_0,
> GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
> CreateReportChunk A_4, Boolean& A_5)
> -- End of inner exception stack trace --
> ReportingServicesService!runningjobs!f54!02/25/2005-20:37:22:: i INFO:
> CancelableJobExecution.Execute caught some other thread abort exception
> ReportingServicesService!library!f54!02/25/2005-20:37:22:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!emailextension!f54!02/25/2005-20:37:24:: Error
> sending email. System.Threading.ThreadAbortException: Thread was being
> aborted.
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> at
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
> type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]& secondaryStreamNames)
> at Microsoft.ReportingServices.Library.ReportImpl.Render(String
> renderFormat, String deviceInfo)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
> message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
> notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> ReportingServicesService!notification!f54!02/25/2005-20:37:25:: Error
> thrown
> by delivery provider: System.Threading.ThreadAbortException: Thread was
> being
> aborted.
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem
> item)
> ReportingServicesService!notification!f54!02/25/2005-20:37:26:: e ERROR:
> Error occured processing notification. Thread was being aborted.
> ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27::
> NotificationPolling no longer processing item
> 36b6fea8-ebac-4de7-b5ef-74c792df8276, will be requeued
> ReportingServicesService!dbpolling!f54!02/25/2005-20:37:27:: Queue worker
> thread caught unhandled exception: System.Threading.ThreadAbortException:
> Thread was being aborted.
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem
> item)
> at
> Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem
> item)
> at
> Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
> state)
>

Pausing Log Shipping Plans

We are doing an IP Restructuring on our DR site over the weekend due to some business and management requirements.I actually have 2 questions. I have implemented log shipping plans for our databases. Which means I will have to pause (disable) my log shipping plans while this is being done and resume (re-enable) after everything is comlete.

Any insights on what else I need to do apart from these?

My second question is this. I am generating transaction log backups every 15 minutes and is averaging at 350MB (this much data every 15 minutes - not to mention that I've got around 40+ databases, all configured for log shipping just for this instance alone). My alert threshold is 45 minutes. My log shipping plan for one database starts failing probably because 15 minutes is not enough to transfer 300+MB-sized backup file over a WAN locate across the globe on a not-so-high bandwidth and restore it to the destination. Any recommendations on this apart from increasing the threshold? Your assistance is highly appreciated

Log shipping should not be affected by changing the IP addresses unless you change ones targetted directly by the log shipping jobs. For the WAN case, you can consider adding a step to compress the transaction log backups prior to copying them over the network. This typically improves the end-toend throughput over a WAN.

Regards,

Matt Hollingsworth

Sr. Program Manager

SQL Server High Availability

|||

Hi Matt,

Thanks for your reply. Actually, we will be changing the IPs of the destination servers You were mentioning compressing the transaction log backups prior to copying them over the network. I am using the Database maintenance plans to define my log shipping plans. The way I see it, the copy job does a "pull" method - the destination server is the one initiating the job. How do you insert a step to compress the transaction log backup files in the database maintenance plans? I am only allowed to use "Microsoft supported" procedures as per company policy

sql

Pause Log Shipping for Server Maintenace

Is there a graceful best practice to temporarily pause log shipping so that
unrelated Windows maintenance can be carried out on the servers?
Hi John
To pause Log Shipping, one can simply disable the Log Shipping jobs ie., the
Log Shipping Transaction Log Backup job on the Primary Server and the Log
Shipping Transaction Log Copy and Restore jobs on the Secondary Server.
Once the maintenance activity is completed you can enable the jobs again.
Thanks & Regards
Amer M J
MCP
"John Oberlin" wrote:

> Is there a graceful best practice to temporarily pause log shipping so that
> unrelated Windows maintenance can be carried out on the servers?

Pause Log Shipping for Server Maintenace

Is there a graceful best practice to temporarily pause log shipping so that
unrelated Windows maintenance can be carried out on the servers?Hi John
To pause Log Shipping, one can simply disable the Log Shipping jobs ie., the
Log Shipping Transaction Log Backup job on the Primary Server and the Log
Shipping Transaction Log Copy and Restore jobs on the Secondary Server.
Once the maintenance activity is completed you can enable the jobs again.
Thanks & Regards
Amer M J
MCP
"John Oberlin" wrote:
> Is there a graceful best practice to temporarily pause log shipping so that
> unrelated Windows maintenance can be carried out on the servers?

Pause Log Shipping for Server Maintenace

Is there a graceful best practice to temporarily pause log shipping so that
unrelated Windows maintenance can be carried out on the servers?Hi John
To pause Log Shipping, one can simply disable the Log Shipping jobs ie., the
Log Shipping Transaction Log Backup job on the Primary Server and the Log
Shipping Transaction Log Copy and Restore jobs on the Secondary Server.
Once the maintenance activity is completed you can enable the jobs again.
Thanks & Regards
Amer M J
MCP
"John Oberlin" wrote:

> Is there a graceful best practice to temporarily pause log shipping so tha
t
> unrelated Windows maintenance can be carried out on the servers?

Path of SystemDB during SQL Server 2005 Installation

Hello,
During SQL Server 2005 Installation I would like to change the path for .mdf
on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
Can anybody guide me how we can do it?
Thanks in advance,
MBsee the following link
http://support.microsoft.com/kb/224071
VT
"MB" <mital.bhadaniya@.itcinfotech.com> wrote in message
news:OAsMHNcJHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> During SQL Server 2005 Installation I would like to change the path for
> .mdf
> on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
> Can anybody guide me how we can do it?
> Thanks in advance,
> MB
>|||Hello,
During the SETUP process; in the Feature selection, option select database
services; click browse and change the drive and directory
and continue the installation.
Thanks
Hari
"MB" <mital.bhadaniya@.itcinfotech.com> wrote in message
news:OAsMHNcJHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> During SQL Server 2005 Installation I would like to change the path for
> .mdf
> on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
> Can anybody guide me how we can do it?
> Thanks in advance,
> MB
>|||Thank you Vinu & Hari,
Actually I am looking for the specific location only. When we change
location while doing installation it's installing other folders also and the
.mdf & .ldf location won't be exact as we desired an on the same drive.
Hence, the only solution is attached and detached db.
But I am looking for any optins how we can do it on SQL Server 2000. i.e.
specifying exact location for .mdf & .ldf
Best Regards,
Mital Bhadaniya
"MB" <mital.bhadaniya@.itcinfotech.com> wrote in message
news:OAsMHNcJHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> During SQL Server 2005 Installation I would like to change the path for
> .mdf
> on D:\MSSQL\Data\ and .ldf on E:\MSSQL\LOG\ for all the system databases.
> Can anybody guide me how we can do it?
> Thanks in advance,
> MB
>