Thursday, March 29, 2012
Direct Print using URL in 2k5
URL
http://xxx.xxx.xxx.xxx/ReportServer?%2ffolder%2fReport&Parameter=LAPTOP&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html
I saw in a previous post where GetImage is no longer available. This URL
was lifted from behind the print button on the report viewer control in SRS00
SP2. However when I grab the URL in 2k5 we have this
ReportViewerWebControl.axd?ReportSession=
Is there a way to fake this report session so I can still direct URL print?
I have seen the previous posts recomend using the report viewer control,
that works great in some cases just not this one. I dont want to show the
report to the user just promt them to print it.
ThanksHey Fred,
I have the exact same requirement to print directly via a URL. Did you
ever find an answer/solution to this issue? Any help or suggestions/links
you can provide would be most appreciated (I have looked high and lo for
answers).
Michael C
"FredG" wrote:
> In SRS 00 sp2 we were able to call the printer direct by using the following
> URL
> http://xxx.xxx.xxx.xxx/ReportServer?%2ffolder%2fReport&Parameter=LAPTOP&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html
> I saw in a previous post where GetImage is no longer available. This URL
> was lifted from behind the print button on the report viewer control in SRS00
> SP2. However when I grab the URL in 2k5 we have this
> ReportViewerWebControl.axd?ReportSession=> Is there a way to fake this report session so I can still direct URL print?
> I have seen the previous posts recomend using the report viewer control,
> that works great in some cases just not this one. I dont want to show the
> report to the user just promt them to print it.
> Thanks
>sql
Sunday, March 11, 2012
Differential Backups Produce 55GB Files
I should mention that our full backup is typically 10GB, log file backups are typically 100 to 500MB, and the diff backup is generally 1GB to 3GB.
Has anyone experienced this issue before?
What causes it?
How do we resolve it?
Thank you in advance for your help,
Greg
if the log backups occurs every 1 hr you dont need to schedule the differential backup.......moreover check if any process is running at the time of backup......generally if you schedule the backups frequently the log files shudnt grow as high in your case........|||
I'm not worries about the size of the log files. The logs are fine. This post regards the size of the differential backup file itself (55GB). We don't really need it, true, but its much easier to restore one diff backup over six logs in my humble opinion, but this is really beside the point.
|||Was there any unusual activity over the weekend? Someone doing a bunch of bulks loads or index rebuilds for instance?|||Are you appending your differential backups to the same file, or creating a new file for each differential backup?|||Yes. Over the weekend we usually do an index rebuild, and some heavy inserts. Our database is mirrored as well, so we're not able to actually do the heavy inserts as a true bulk insert.|||Each backup creates a new file. A secondary process on another machine copies the files over to another server.|||most probably this is coz of the activities in the weekend. When u rebiult index it take extraspace to create the fresh index . the existing index are not overwritten beacuse if system needs the existing index to rollback if necessary. Differential backup take the backup of all the extents changed from last full backup. So what i would prefer is... take full backup after the weekend maintenance instead of Differential(if you have maintenance window).
Madhu