Backup to Network Drive: via

Showing posts with label via. Show all posts

Thursday, March 22, 2012

Barcode font "shrinks" during PDF export

Hi all,

I'm using a free barcode font so i can create scannable tickets via reporting services 2k5. When I print the tickets, everything seems fine. But when i export to PDF though, it looks like the barcode font shrunk. All the lines are pulled together, making scanning impossible. Is there a certain setting or so that i can use to ensure the font's width ?

-Update-
The weird thing is: when i export it inside visual studio, the barcode is shown as it is supposed to in the pdf !?

Thanks in advance!

Hi,

I am facing the same issue.

Microsoft please reply.

Regards and TIA,

Ashish

|||Did you try to change the Report Properties to set the margin to 0 ?
And make sure your design area does not exceed the paper size set in the property box and exactly fit the paper format on the printer?
I am myself having trouble with pdf page exported from ReportManager not be not too accurate. Kind of a hit and miss trial and error page set-up formating process until it gets right.
Reporting Services is not doing an excellent job at printing things, not from a typography point of view.
Any improvement would be more than welcome.
Philippe|||

sorry for the late reply !

yep i tried that, but hlas, no changes :(

|||

Hi,

I hate to say this, but we really did nothing to resolve the issue. Nor did I get any replies for this issue.

We just restarted the SSRS server for some reason and after that we found that it was working fine. I would suggest that you give it a shot restart the server and it may click in your case also.

HTH

Regards,

Ashish

|||

I have seen several barcode fonts that do not include the correct spacing or at least do not report the correct spacing through the Win32 APIs our PDF renderer calls. It's also very possible we have a bug in that area.

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

In my own experience, the barcod39.ttf TrueType font renders properly in every renderer except pdf. In pdf, it appears to arbitrarily expand spaces to fill the control.

I'd love to see that fixed.

Tim Bailey
Energy Laboratories, Inc.

Barcode font "shrinks" during PDF export

Hi all,

-Update-
The weird thing is: when i export it inside visual studio, the barcode is shown as it is supposed to in the pdf !?

Thanks in advance!

Hi,

I am facing the same issue.

Microsoft please reply.

Regards and TIA,

Ashish

sorry for the late reply !

yep i tried that, but hlas, no changes :(

|||

Hi,

I hate to say this, but we really did nothing to resolve the issue. Nor did I get any replies for this issue.

We just restarted the SSRS server for some reason and after that we found that it was working fine. I would suggest that you give it a shot restart the server and it may click in your case also.

HTH

Regards,

Ashish

|||

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

In my own experience, the barcod39.ttf TrueType font renders properly in every renderer except pdf. In pdf, it appears to arbitrarily expand spaces to fill the control.

I'd love to see that fixed.

Tim Bailey
Energy Laboratories, Inc.

Barcode font "shrinks" during PDF export

Hi all,

-Update-
The weird thing is: when i export it inside visual studio, the barcode is shown as it is supposed to in the pdf !?

Thanks in advance!

Hi,

I am facing the same issue.

Microsoft please reply.

Regards and TIA,

Ashish

sorry for the late reply !

yep i tried that, but hlas, no changes :(

|||

Hi,

I hate to say this, but we really did nothing to resolve the issue. Nor did I get any replies for this issue.

We just restarted the SSRS server for some reason and after that we found that it was working fine. I would suggest that you give it a shot restart the server and it may click in your case also.

HTH

Regards,

Ashish

|||

If you file a bug at http://connect.microsoft.com and include the rdl and font, I'll gladly take a look.

Thanks,

Donovan Smith

|||

In my own experience, the barcod39.ttf TrueType font renders properly in every renderer except pdf. In pdf, it appears to arbitrarily expand spaces to fill the control.

I'd love to see that fixed.

Tim Bailey
Energy Laboratories, Inc.

Sunday, March 11, 2012

Backward Compatability in Yukon using backup devices?

My peers have informed me that I should no longer code my backup routine
using a backup alias via sp_addumpdevice because it is 1) Provided only for
backward compatability and 2) Will not be supported in the future.
Should I not be using a backup alias for these reasons? Yukon provides the
commands but no where have I seen where it's only there to support backward
compatability and that it is targeted to be phased out. Can someone show me
this?
Thanks.
-CqlboyI know nothing of dump devices going away any time soon.
--
Andrew J. Kelly SQL MVP
"Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
news:4332439A-418D-450F-BD94-5579374C40F3@.microsoft.com...
> My peers have informed me that I should no longer code my backup routine
> using a backup alias via sp_addumpdevice because it is 1) Provided only
> for
> backward compatability and 2) Will not be supported in the future.
> Should I not be using a backup alias for these reasons? Yukon provides
> the
> commands but no where have I seen where it's only there to support
> backward
> compatability and that it is targeted to be phased out. Can someone show
> me
> this?
> Thanks.
> -Cqlboy|||Thanx. Thought so. My fellow peers
are misinformed.
-Cqlboy
"Andrew J. Kelly" wrote:
> I know nothing of dump devices going away any time soon.
> --
> Andrew J. Kelly SQL MVP
>
> "Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
> news:4332439A-418D-450F-BD94-5579374C40F3@.microsoft.com...
> > My peers have informed me that I should no longer code my backup routine
> > using a backup alias via sp_addumpdevice because it is 1) Provided only
> > for
> > backward compatability and 2) Will not be supported in the future.
> >
> > Should I not be using a backup alias for these reasons? Yukon provides
> > the
> > commands but no where have I seen where it's only there to support
> > backward
> > compatability and that it is targeted to be phased out. Can someone show
> > me
> > this?
> >
> > Thanks.
> >
> > -Cqlboy
>
>|||I'm with Andrew. Ask your colleagues for a reference. It is easy to make claims you can't back up...
:-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
news:B4044417-68A3-401F-B1AF-7BCE37AE1BC9@.microsoft.com...
> Thanx. Thought so. My fellow peers
> are misinformed.
> -Cqlboy
> "Andrew J. Kelly" wrote:
>> I know nothing of dump devices going away any time soon.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Cqlboy" <Cqlboy@.discussions.microsoft.com> wrote in message
>> news:4332439A-418D-450F-BD94-5579374C40F3@.microsoft.com...
>> > My peers have informed me that I should no longer code my backup routine
>> > using a backup alias via sp_addumpdevice because it is 1) Provided only
>> > for
>> > backward compatability and 2) Will not be supported in the future.
>> >
>> > Should I not be using a backup alias for these reasons? Yukon provides
>> > the
>> > commands but no where have I seen where it's only there to support
>> > backward
>> > compatability and that it is targeted to be phased out. Can someone show
>> > me
>> > this?
>> >
>> > Thanks.
>> >
>> > -Cqlboy
>>

Friday, February 24, 2012

Backup/Restore Status

Very often I have to do large backup and restores. This is either done via jobs, or the SQL Maintance tools. Neither so any status of a backup/restore. Overall progress, bytes written, etc. EM when backing up or restoring does show a GUI progress bar that isn't perfect, but does show progress to some extent.
So far I can look in the sysprocesses tables and find what spid is running the command, but that doesn't tell me much. The console command line util is for tape backups. Is there anything that can monitor the progress of backups and restores.
Thanks,
ETThe native SQL Server BACKUP and RESTORE commands have a STATUS parameter,
that when specified, returns status messages, indicating the progress of the
backup/restore operation.
Here's an example:
RESTORE DATABASE YourDB FROM DISK='\\SomePath\SomeFile.BAK' WITH STATUS = 1
See, SQL Server Books Online for more information.
Note that, even after specifying the STATUS with BACKUP or RESTORE command,
you will not see any progress messages coming up, while SQL Server is
creating the file.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Twiggy" <etwilegar@.nospamttgonline.com> wrote in message
news:D4500856-A29C-44EF-A7E8-828D7F6DDBCD@.microsoft.com...
Very often I have to do large backup and restores. This is either done via
jobs, or the SQL Maintance tools. Neither so any status of a backup/restore.
Overall progress, bytes written, etc. EM when backing up or restoring does
show a GUI progress bar that isn't perfect, but does show progress to some
extent.
So far I can look in the sysprocesses tables and find what spid is running
the command, but that doesn't tell me much. The console command line util is
for tape backups. Is there anything that can monitor the progress of
backups and restores.
Thanks,
ET|||Well I knew that EM was doing this and grabbing the results. In this case I'm not in control of the actual restore command. The command is already running, is there a way for another connection to get status on the operation. Is there a system table that information is written to?|||No Twiggy, there is not...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Twiggy" <etwilegar@.ttgonline.com> wrote in message
news:72E2D27A-36B1-4013-94D8-04A60F0A8782@.microsoft.com...
> Well I knew that EM was doing this and grabbing the results. In this case
I'm not in control of the actual restore command. The command is already
running, is there a way for another connection to get status on the
operation. Is there a system table that information is written to?
>|||I find this really weird. I wonder how the heck their internal developers debug backup/restore issues. I guess the code for backup and restoring hasn't changed a lot since 7, but still I'm sure there is a switch that would turn on logging of some sort. I'd hate to be the guy that had to write the Enterprise manager code, parsing the text output from restore with status.
Guess I'll wait for mirroring.

Monday, February 13, 2012

Backup via Maintenance Plan

Hi all,
Just a quick question. I've searched through the docs for this but am still
not certain. Can you tell me if, during a Maintenance Plan's backup
procedure, the database is still available or does the MP put it into
Single-User Mode / Offline?
Cheers,
IMAs in all backups, the database is available to all users.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
news:E1C32915-5794-45BF-BE2F-513937DBCD1A@.microsoft.com...
Hi all,
Just a quick question. I've searched through the docs for this but am still
not certain. Can you tell me if, during a Maintenance Plan's backup
procedure, the database is still available or does the MP put it into
Single-User Mode / Offline?
Cheers,
IM|||Many thanks Tom. That's what I thought but it's good to know for sure.
Cheers,
IM
"Tom Moreau" wrote:
> As in all backups, the database is available to all users.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "Ian Murphy" <IanMurphy@.discussions.microsoft.com> wrote in message
> news:E1C32915-5794-45BF-BE2F-513937DBCD1A@.microsoft.com...
> Hi all,
> Just a quick question. I've searched through the docs for this but am still
> not certain. Can you tell me if, during a Maintenance Plan's backup
> procedure, the database is still available or does the MP put it into
> Single-User Mode / Offline?
> Cheers,
> IM
>|||This is a multi-part message in MIME format.
--010201060107060106030405
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
This is true but there are a few file management type operations that
cannot run while a backup is in progress:
* ALTER DATABASE (with ADD FILE or REMOVE FILE)
* DBCC SHRINKDATABASE
* DBCC SHRINKFILE
A backup won't start while these are in progress and you can't start one
of these operations while a backup is in progress.
--
*mike hodgson*
/ mallesons stephen jaques/
blog: http://sqlnerd.blogspot.com
Tom Moreau wrote:
>As in all backups, the database is available to all users.
>
>
--010201060107060106030405
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>This is true but there are a few file management type operations
that cannot run while a backup is in progress: 
</tt>
<ul>
<li><tt>ALTER DATABASE (with ADD FILE or REMOVE FILE)</tt></li>
<li><tt>DBCC SHRINKDATABASE</tt></li>
<li><tt>DBCC SHRINKFILE</tt></li>
</ul>
<tt>A backup won't start while these are in progress and you can't
start one of these operations while a backup is in progress. 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson 
 mallesons stephen jaques 
blog: <a href="http://links.10026.com/?link=/">http://sqlnerd.blogspot.com">
http://sqlnerd.blogspot.com</a> 
</div>
 
 
Tom Moreau wrote:
<blockquote cite="miduOjdsJ%23dFHA.1136@.TK2MSFTNGP12.phx.gbl"
type="cite">
<pre wrap="">As in all backups, the database is available to all users.
</pre>
</blockquote>
</body>
</html>
--010201060107060106030405--

Backup via Maintenance Plan

Friday, February 10, 2012

Backup to Location over VPN

Hi,
I am having problems with creating a backup onto a machine that is connected to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specified, yet when i use Windows explorer I can copy and paste to my hearts content.
I was just wondering if the backup of a database can be done to a location over a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Backup to Location over VPN

Hi,
I am having problems with creating a backup onto a machine that is connected
to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specif
ied, yet when i use Windows explorer I can copy and paste to my hearts conte
nt.
I was just wondering if the backup of a database can be done to a location o
ver a VPN.
Thanks in Advance
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.Backups are done under the account that SQL Server runs under, not the
account you are using when you log in to QA or EM. SQL Server is most
likely running under the local service account which knows nothing of the
VPN or the Domain.
Andrew J. Kelly SQL MVP
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uhIiucxbEHA.252@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having problems with creating a backup onto a machine that is
connected to the domain via a VPN connection.
> When i do the back up it does not recognize the directory that I have
specified, yet when i use Windows explorer I can copy and paste to my hearts
content.
> I was just wondering if the backup of a database can be done to a location
over a VPN.
> Thanks in Advance
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Thursday, March 22, 2012

Barcode font "shrinks" during PDF export

Barcode font "shrinks" during PDF export

Barcode font "shrinks" during PDF export

Sunday, March 11, 2012

Backward Compatability in Yukon using backup devices?

Backward Compatability in Yukon using backup devices?

Backward Compatability in Yukon using backup devices?

Friday, February 24, 2012

Backup/Restore Status

Monday, February 13, 2012

Backup via Maintenance Plan

Backup via Maintenance Plan

Backup via Maintenance Plan

Friday, February 10, 2012

Backup to Location over VPN

Backup to Location over VPN

Backup to Network Drive

Blog Archive

About Me