When I try to backup a SQL 2000 database I recieve the following error in
the output log. Any ideas? Thank you.
SQL 2000 w/ SP4
[39] Database SolRounder: Database Backup...
Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK]
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC SQL
Server Driver][SQL Server]Write on
'G:\Backups\SolRounder\SolRounder_db_200704131221.BAK' failed, status = 112.
See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
terminating abnormally.
[40] Database SolRounderKids: Database Backup...
Destination:
[G:\Backups\SolRounderKids\SolRounderKids_db_200704131223.BAK]Gabe,
Error 112 is probably the Windows ERROR_DISK_FULL, which means that your G:
drive does not have enough space to hold your backup file.
See if you can clean up some things from the drive to give it more space.
RLF
"Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message
news:Oz8yowefHHA.4552@.TK2MSFTNGP04.phx.gbl...
> When I try to backup a SQL 2000 database I recieve the following error in
> the output log. Any ideas? Thank you.
> SQL 2000 w/ SP4
> [39] Database SolRounder: Database Backup...
> Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK]
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC
> SQL Server Driver][SQL Server]Write on
> 'G:\Backups\SolRounder\SolRounder_db_200704131221.BAK' failed, status => 112. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
> terminating abnormally.
> [40] Database SolRounderKids: Database Backup...
> Destination:
> [G:\Backups\SolRounderKids\SolRounderKids_db_200704131223.BAK]
>|||Working now. Thank you Russell!
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:ueOlD4efHHA.4552@.TK2MSFTNGP04.phx.gbl...
> Gabe,
> Error 112 is probably the Windows ERROR_DISK_FULL, which means that your
> G: drive does not have enough space to hold your backup file.
> See if you can clean up some things from the drive to give it more space.
> RLF
> "Gabe Matteson\" <gmatteson.rounder.com.nospam> wrote in message
> news:Oz8yowefHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> When I try to backup a SQL 2000 database I recieve the following error in
>> the output log. Any ideas? Thank you.
>> SQL 2000 w/ SP4
>> [39] Database SolRounder: Database Backup...
>> Destination: [G:\Backups\SolRounder\SolRounder_db_200704131221.BAK]
>> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3202: [Microsoft][ODBC
>> SQL Server Driver][SQL Server]Write on
>> 'G:\Backups\SolRounder\SolRounder_db_200704131221.BAK' failed, status =>> 112. See the SQL Server error log for more details.
>> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
>> terminating abnormally.
>> [40] Database SolRounderKids: Database Backup...
>> Destination:
>> [G:\Backups\SolRounderKids\SolRounderKids_db_200704131223.BAK]
>
Showing posts with label ideas. Show all posts
Showing posts with label ideas. Show all posts
Sunday, March 25, 2012
Tuesday, March 20, 2012
Background water mark
It would be really cool to sort of ghost our company logo as a background
beneath report content.
Any ideas on how to do this are welcome?
All the Best,
GHello Joe,
Reporting Services doesn't have a specific way to produce watermarks, but
you can create them manually.
Watermark at the printer level
Look at the capacities of the printer driver you use to create a paper copy
of the report. Many printers, even low-end ones, have the ability to add
watermarks as part of the print process. This is usually defined in the
printer driver's settings. It can be configured by creating a separate
instance of an existing printer driver and then configuring that instance
to add a watermark to all output. Adding another instance of a printer
driver does not take much system overhead, so this is economical and
convenient. To produce the watermarked edition of a document, just print to
the right instance of the printer driver.
Watermark at the report level
If you want to add the watermark on the report level, there are a few ways
to do this. You may simply create a bitmap with the appropriate watermark
on it and set that as a background image for the header, body or footer of
the report. Another approach would be to create a textbox behind the report
grid and place the needed watermarking there. In both cases, you would
probably need to set the background for all cells on the grid to
"Transparent" so that the background items would show through; any colored
items (even if they use white) would overprint the image.
Another possibility is to create a textbox for the watermark, make the
background of that textbox transparent, and bring it to the top of the
Z-order for the report, so it remains on top of everything else.
Here is the article I reference:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1163757,00.html
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Wei Lu,
Thank you for the definitive reply, I have noticed that Report Services
does not like to place other objects on top of Image components.
Setting up additional printer definitions would be easy, however it would
certainly confuse and aggravate the average user.
I will try your other suggestions and post the results.
All the best,
Greg Rowland|||My Pleasure, Greg.
If you have any question, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Greg,
Have you tested the suggestion? Anything I can help, please feel free to
let me know.
Sincerely,
Wei Lu
Microsoft Online Community 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.
beneath report content.
Any ideas on how to do this are welcome?
All the Best,
GHello Joe,
Reporting Services doesn't have a specific way to produce watermarks, but
you can create them manually.
Watermark at the printer level
Look at the capacities of the printer driver you use to create a paper copy
of the report. Many printers, even low-end ones, have the ability to add
watermarks as part of the print process. This is usually defined in the
printer driver's settings. It can be configured by creating a separate
instance of an existing printer driver and then configuring that instance
to add a watermark to all output. Adding another instance of a printer
driver does not take much system overhead, so this is economical and
convenient. To produce the watermarked edition of a document, just print to
the right instance of the printer driver.
Watermark at the report level
If you want to add the watermark on the report level, there are a few ways
to do this. You may simply create a bitmap with the appropriate watermark
on it and set that as a background image for the header, body or footer of
the report. Another approach would be to create a textbox behind the report
grid and place the needed watermarking there. In both cases, you would
probably need to set the background for all cells on the grid to
"Transparent" so that the background items would show through; any colored
items (even if they use white) would overprint the image.
Another possibility is to create a textbox for the watermark, make the
background of that textbox transparent, and bring it to the top of the
Z-order for the report, so it remains on top of everything else.
Here is the article I reference:
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1163757,00.html
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Wei Lu,
Thank you for the definitive reply, I have noticed that Report Services
does not like to place other objects on top of Image components.
Setting up additional printer definitions would be easy, however it would
certainly confuse and aggravate the average user.
I will try your other suggestions and post the results.
All the best,
Greg Rowland|||My Pleasure, Greg.
If you have any question, please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||Hello Greg,
Have you tested the suggestion? Anything I can help, please feel free to
let me know.
Sincerely,
Wei Lu
Microsoft Online Community 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.
Backend generate and save the report to local drive?
Hi,
Any ideas on how to automatically generate and save the report to local
server drive backend when user click on certain link on the application?
The user do not have to render and display the report in frontend or click
on save button when prompted? The system should not prompt user for any
action instead.
Thanks in advance for any suggestion.Hi,
you can call the WebService of reporting Services (with optional
additional parameters, get the byte[] from the render method and save
this in a file on your network share of choice. That can all happen
behind the scenes and in addition if you want to asynchronously.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--
Any ideas on how to automatically generate and save the report to local
server drive backend when user click on certain link on the application?
The user do not have to render and display the report in frontend or click
on save button when prompted? The system should not prompt user for any
action instead.
Thanks in advance for any suggestion.Hi,
you can call the WebService of reporting Services (with optional
additional parameters, get the byte[] from the render method and save
this in a file on your network share of choice. That can all happen
behind the scenes and in addition if you want to asynchronously.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--
Subscribe to:
Posts (Atom)