Basic Functionality Questions

We've been trying to implement Reporting Services in our web application. We've run into 2 issues that I'd like to verify:

First, HTML rendering. In our application we provide an HTML Editor for formatting. The formatting does not render in the reporting services. I understand that's a known issue with no work around and no timeframe for resolution. Is that correct?

Second issue comes with tying is the Reporting Services together with our ASP.NET code. Do any of the Reporting Services controls allow you to bind to classes that support the IList Interface?

Thanks,

Frank

1) RS text box control does not render HTML. It supports standard formatting which applies to the entire contents of the textbox rather than individual bits of text as in a rich text box control.

2) RS reports are rendered based on the report definition and do not support binding custom datasets at runtime through the IList interface.

sql

Basic authentication.

The documentation for Analysis Services seems to suggest that windows authentication is no longer the only way of accessing AS.

I'm trying to confirm whether or not it is possible to login to AS with basic authentication. If so, what are the constraints (eg is this possible only via IIS).

I'd also like to find out if http access is restricted to enterprise edition only like it was in AS2000, or has the scope been widened in AS2005.

Thanks,
Terry.
Basic authentication only works for http/https connectivity (where the username and password are passed to IIS for impersonation).

For native connections (when you directly connect to AS2005) the user name and password are ignored if specified in the connection string.

(and when connecting to local cube files, the password is used as decryption key)

Adrian Dumitrascu.|||

Thanks Adrian. That helps.

I'm keen to find out if http/https connectivity (via IIS) will be available in the standard edition in AS2005. Is this information available at present?

Terry.

|||Yes, http/https connectivity will be available in AS2005 standard edition.

Adrian Dumitrascu.

Barcodes in PDF

Hi there
I am creating a report with MS SQL reporting services 2000 that includes a
barcode. It 's for a kind of ticket creation.
So, I am using the Code 3of9 font to create my barcodes. So for example
*01511051* is the text, but font type is code 3àf9, giving the barcode in
display
When exporting to HTML, there is no issue, barcode is displayed fine, as
well as in the preview of visual studio. But as soon as I export it to PDF,
the barcode is gone.
Is there anyone that has some experience in this? How can I resolve this?
Weird thing is that when creating the same report in Crystal Reports and
exporting to PDF, it does render the barcode. But Crystal reports is not an
option, it has to be done in reporting services 2000
kind regards
NicoNico,
What happens if u just use standard font?
Does it display it in the PDF?
If it does, perhaps its a Adobe font issue...(I dont know about this,
but perhaps the font needs to be added into it?)
If it doesn't even show the plain (*01511051*), then it may be a
different problem, but Im almost sure its a Abode font issue.
Also,
Choose Start > Settings > Control Panel.
Double-click the Fonts icon, check if that font is located there.
regards,
Stas K.|||Hi
It does not display anything at all when exporting to PDF format. It's just
a blank area on the pdf, whereas in the HTML output, the barcode is
displayed properly
"Sorcerdon" <sorcerdon@.gmail.com> wrote in message
news:1144856853.406170.30120@.g10g2000cwb.googlegroups.com...
> Nico,
> What happens if u just use standard font?
> Does it display it in the PDF?
> If it does, perhaps its a Adobe font issue...(I dont know about this,
> but perhaps the font needs to be added into it?)
> If it doesn't even show the plain (*01511051*), then it may be a
> different problem, but Im almost sure its a Abode font issue.
> Also,
> Choose Start > Settings > Control Panel.
> Double-click the Fonts icon, check if that font is located there.
> regards,
> Stas K.
>|||Hello!
We (TEC-IT) offer a barcode software component named TBarCode OCX which is
available as ActiveX control and as DLL. Download the trial version from
http://www.tec-it.com
If you have troubles embedding the component into your reports please
contact us via email (support@.tec-it.com)
Hope this helps!
Guenter
"NDE" wrote:
> Hi
> It does not display anything at all when exporting to PDF format. It's just
> a blank area on the pdf, whereas in the HTML output, the barcode is
> displayed properly
> "Sorcerdon" <sorcerdon@.gmail.com> wrote in message
> news:1144856853.406170.30120@.g10g2000cwb.googlegroups.com...
> > Nico,
> >
> > What happens if u just use standard font?
> > Does it display it in the PDF?
> > If it does, perhaps its a Adobe font issue...(I dont know about this,
> > but perhaps the font needs to be added into it?)
> > If it doesn't even show the plain (*01511051*), then it may be a
> > different problem, but Im almost sure its a Abode font issue.
> >
> > Also,
> > Choose Start > Settings > Control Panel.
> > Double-click the Fonts icon, check if that font is located there.
> >
> > regards,
> > Stas K.
> >
>
>

barcode missing when printing from reporting services

I am using a barcode font 39 to generate barcodes in some reports. If I
reader the report and save it to a excel spreedsheet and print then the
report prints fine with the barcode.
If while I am in the browser I use the reporting services print engine the
barcode comes out as the numbers ie *12345* instead of the barcode font. The
numbers also come up in the preview of the printing.
I have installed the font on the local and reporting service computersI have just also found that if I export to Excel the barcode works but if I
export to PDF it doesn't.
"John230873" wrote:
> I am using a barcode font 39 to generate barcodes in some reports. If I
> reader the report and save it to a excel spreedsheet and print then the
> report prints fine with the barcode.
> If while I am in the browser I use the reporting services print engine the
> barcode comes out as the numbers ie *12345* instead of the barcode font. The
> numbers also come up in the preview of the printing.
> I have installed the font on the local and reporting service computers|||John,
I had the same problem. I wish Microsoft would release a fix to the problem
but I found a work-around by making the textbox (that holds the barcode in
the [rdl]) 3 times larger than the required size. This will of course mess
up your design.
Frank
"John230873" wrote:
> I have just also found that if I export to Excel the barcode works but if I
> export to PDF it doesn't.
> "John230873" wrote:
> > I am using a barcode font 39 to generate barcodes in some reports. If I
> > reader the report and save it to a excel spreedsheet and print then the
> > report prints fine with the barcode.
> >
> > If while I am in the browser I use the reporting services print engine the
> > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > numbers also come up in the preview of the printing.
> >
> > I have installed the font on the local and reporting service computers|||I am using a barcode and it is working perfectly. I had to find an assembly
for the solution which can be found here...
http://www.bizfonts.com/MicrosoftReportingServices/
HTH
"Frank" wrote:
> John,
> I had the same problem. I wish Microsoft would release a fix to the problem
> but I found a work-around by making the textbox (that holds the barcode in
> the [rdl]) 3 times larger than the required size. This will of course mess
> up your design.
> Frank
> "John230873" wrote:
> > I have just also found that if I export to Excel the barcode works but if I
> > export to PDF it doesn't.
> >
> > "John230873" wrote:
> >
> > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > reader the report and save it to a excel spreedsheet and print then the
> > > report prints fine with the barcode.
> > >
> > > If while I am in the browser I use the reporting services print engine the
> > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > numbers also come up in the preview of the printing.
> > >
> > > I have installed the font on the local and reporting service computers|||I need to generate a report with barcodes.
Are there any samples available that will show me how to do this?
Do I need to purchase a third-party component?
Thanks,
Scott
"DigitalVixen" wrote:
> I am using a barcode and it is working perfectly. I had to find an assembly
> for the solution which can be found here...
> http://www.bizfonts.com/MicrosoftReportingServices/
> HTH
> "Frank" wrote:
> > John,
> >
> > I had the same problem. I wish Microsoft would release a fix to the problem
> > but I found a work-around by making the textbox (that holds the barcode in
> > the [rdl]) 3 times larger than the required size. This will of course mess
> > up your design.
> >
> > Frank
> >
> > "John230873" wrote:
> >
> > > I have just also found that if I export to Excel the barcode works but if I
> > > export to PDF it doesn't.
> > >
> > > "John230873" wrote:
> > >
> > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > reader the report and save it to a excel spreedsheet and print then the
> > > > report prints fine with the barcode.
> > > >
> > > > If while I am in the browser I use the reporting services print engine the
> > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > numbers also come up in the preview of the printing.
> > > >
> > > > I have installed the font on the local and reporting service computers|||I too tried to use the assembly, but it did not fix the problem? Any
suggestions? I follwed the directions to a "T". Did you have to "tweak"
anything to get it to work for you?
"DigitalVixen" wrote:
> I am using a barcode and it is working perfectly. I had to find an assembly
> for the solution which can be found here...
> http://www.bizfonts.com/MicrosoftReportingServices/
> HTH
> "Frank" wrote:
> > John,
> >
> > I had the same problem. I wish Microsoft would release a fix to the problem
> > but I found a work-around by making the textbox (that holds the barcode in
> > the [rdl]) 3 times larger than the required size. This will of course mess
> > up your design.
> >
> > Frank
> >
> > "John230873" wrote:
> >
> > > I have just also found that if I export to Excel the barcode works but if I
> > > export to PDF it doesn't.
> > >
> > > "John230873" wrote:
> > >
> > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > reader the report and save it to a excel spreedsheet and print then the
> > > > report prints fine with the barcode.
> > > >
> > > > If while I am in the browser I use the reporting services print engine the
> > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > numbers also come up in the preview of the printing.
> > > >
> > > > I have installed the font on the local and reporting service computers|||This is the best barcode solution for Reporting Services.
All export file formats supported!!!
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
"HeroTheCat" wrote:
> I too tried to use the assembly, but it did not fix the problem? Any
> suggestions? I follwed the directions to a "T". Did you have to "tweak"
> anything to get it to work for you?
> "DigitalVixen" wrote:
> > I am using a barcode and it is working perfectly. I had to find an assembly
> > for the solution which can be found here...
> >
> > http://www.bizfonts.com/MicrosoftReportingServices/
> >
> > HTH
> >
> > "Frank" wrote:
> >
> > > John,
> > >
> > > I had the same problem. I wish Microsoft would release a fix to the problem
> > > but I found a work-around by making the textbox (that holds the barcode in
> > > the [rdl]) 3 times larger than the required size. This will of course mess
> > > up your design.
> > >
> > > Frank
> > >
> > > "John230873" wrote:
> > >
> > > > I have just also found that if I export to Excel the barcode works but if I
> > > > export to PDF it doesn't.
> > > >
> > > > "John230873" wrote:
> > > >
> > > > > I am using a barcode font 39 to generate barcodes in some reports. If I
> > > > > reader the report and save it to a excel spreedsheet and print then the
> > > > > report prints fine with the barcode.
> > > > >
> > > > > If while I am in the browser I use the reporting services print engine the
> > > > > barcode comes out as the numbers ie *12345* instead of the barcode font. The
> > > > > numbers also come up in the preview of the printing.
> > > > >
> > > > > I have installed the font on the local and reporting service computers

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,

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,

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 export to pdf solutions

Hey all,
I'm trying to decide on a barcode product for Reporting Services (SQL Server 2000 and .Net 1.1) so that I can export reports to pdf and retain the barcodes.
I've found IDAutomationhttp://www.idautomation.com/fonts/tools/reporting_services/ and NeoDynamicshttp://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7 as a solution.
I was wondering if anyone has ever used either of these products to create reports for pdf export w/ barcodes? Or possibly another solution? If so, please let me know how it went.
Thanks,
Mike

Go forNeodynamic. Its product supports SSRS 2000 and in addition it's SSRS 2005 fully integrated :-)sql

Barcode Control

Hi,
I am searching for a free tool to generate Barcodes in SQL Report Services.
Has anyone an idea?
Regards OttoOn Oct 9, 3:57 pm, "Otto Hermann" <entwickl...@.idicos.de> wrote:
> Hi,
> I am searching for a free tool to generate Barcodes in SQL Report Services.
> Has anyone an idea?
> Regards Otto
This has been a commonly asked question in this Usenet group. The
closest you will most likely come to a free add-in can be found here:
http://www.technoriversoft.com/freebarcodesoftware.html
Otherwise, there are several that are available for a fee.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Bar Charts in Reporting Services

Hi,
can any one help me about bar charts.how to create bar charts in
reporting services.
Thanks in advance
Malli"How to add, move, or delete a chart (Report Designer)" in Reporting Services
Books Online would be a good place to start.
"Malli" wrote:
> Hi,
> can any one help me about bar charts.how to create bar charts in
> reporting services.
>
> Thanks in advance
> Malli

Bad Login/Password...how to correct it?

How do I change the login/password Reporting Services uses to connect to
SQL Server?
How do I reconfigure the options I chose when I installed SQL Server
Reporting Services in the first place?
Help!?!?rsconfig.exe -c
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JC Ford" <johncford@.hotmail.com> wrote in message
news:eSa0kGvfEHA.592@.TK2MSFTNGP11.phx.gbl...
> How do I change the login/password Reporting Services uses to connect to
> SQL Server?
> How do I reconfigure the options I chose when I installed SQL Server
> Reporting Services in the first place?
> Help!?!?|||Thanks!
Tudor Trufinescu (MSFT) wrote:
> rsconfig.exe -c
>

Bad Installation But Cannot Uninstall Reporting Services - Need He

I seem to have had a problem regarding my installation of SQL Server 2005 -
Developer Edition on my Windows XP Pro machine. I have tried to uninstall
either Reporting Services or all of SQL Server. However, it keeps getting
stuck in the Uninstall of Reporting Services and then does a rollback.
The error that I am getting in each case is as follows:
Setup failed to read IISMEMMAP TABLE. The Errorcode is -2147024893.
Does anyone know how to get out of this so I can try to fix the installation?
Thanks for any advice.
--
John GallagherHi John,
You may try using the tools below to remove SQL Server 2005 manually
Description of the Windows Installer CleanUp Utility
http://support.microsoft.com/kb/290301/en-us
Sincerely yours,
Michael Cheng
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.

bad excel performance / capacity question

a web application that i have recently deployed uses reporting services and exports data to excel reports with drill down options

i have reports that are being generated up to 5 MB and are not usable in excel (i.e. scrolling freezes, slow opening times, large file size)

the reason for this is the detail displayed for each record

each record has a drop down of approximatley 4-6 rows of detail

a report with 3000 lines will have those 4-6 rows of detail for each record

shouldn't excel be able to handle this?

the reports also take a long time to generate and i have had timeout issues, i was able to set the webservice that generates the reports to have no timeout to resolve this problem, my bigger concern is why excel performs so slowly and why the file size is so large

previously we ran these reports out of access, and instead of having the reporting services format, we displayed detail information across as columns and there was no performance issue with the same amount of data

the problems seems to be with out excel handles the (+) signs

Hi,

I also have this problem and it is a big problem according to my customers - I've contacted Microsoft via an incident.

The MS's answer was : the SSRS Excel renderer is the problem and it shall be solved in the next SQL Server version (completely rewritten). Not earlier, and there is no possibility to fix it now.

The only workaround I've found:

1. the main point is to open the exported excel file for the 1.time (you have simply to wait until it opens) and then copy-paste as values the whole sheet. save the file after this, the next time you open it you will see performance improvement.

2. maybe you can split the report into smaller parts - this means less data but more reports

3. you can modify the renderer by setting OMIT_FORMULAS to true in the renderer's config file (there will be no formulas exported, all is exported as values)

The only what really helps is the point 1.

Not only the (+) sign is the problem. I have a report exporting 7000 of rows in 20 columns and there is a problem too.

Hope this helps, if someone has more ideas please let me know, I would also appreciate it.

Jan

|||I would guess that you have a significant number of merged cells in your generated report, due to alignment issues in the RDL. Excel has known issues when loading a spreadsheet with many merge cells. The Excel Export in RS uses merged cells to maintain the layout defined in RDL, and if you have many rows, this can result in large numbers of merged cells.

Check out Chris's blog entry on merging cells and how to reduce them:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx
|||

interesting...thanks for the answer

but there are no merged columns in my problematic excel file...and how is it possible that after copy-paste as values of the whole sheet becomes the opening and working with the excel file non-problematic...?

bad excel performance / capacity question

a web application that i have recently deployed uses reporting services and exports data to excel reports with drill down options

i have reports that are being generated up to 5 MB and are not usable in excel (i.e. scrolling freezes, slow opening times, large file size)

the reason for this is the detail displayed for each record

each record has a drop down of approximatley 4-6 rows of detail

a report with 3000 lines will have those 4-6 rows of detail for each record

shouldn't excel be able to handle this?

the reports also take a long time to generate and i have had timeout issues, i was able to set the webservice that generates the reports to have no timeout to resolve this problem, my bigger concern is why excel performs so slowly and why the file size is so large

previously we ran these reports out of access, and instead of having the reporting services format, we displayed detail information across as columns and there was no performance issue with the same amount of data

the problems seems to be with out excel handles the (+) signs

Hi,

I also have this problem and it is a big problem according to my customers - I've contacted Microsoft via an incident.

The MS's answer was : the SSRS Excel renderer is the problem and it shall be solved in the next SQL Server version (completely rewritten). Not earlier, and there is no possibility to fix it now.

The only workaround I've found:

1. the main point is to open the exported excel file for the 1.time (you have simply to wait until it opens) and then copy-paste as values the whole sheet. save the file after this, the next time you open it you will see performance improvement.

2. maybe you can split the report into smaller parts - this means less data but more reports

3. you can modify the renderer by setting OMIT_FORMULAS to true in the renderer's config file (there will be no formulas exported, all is exported as values)

The only what really helps is the point 1.

Not only the (+) sign is the problem. I have a report exporting 7000 of rows in 20 columns and there is a problem too.

Hope this helps, if someone has more ideas please let me know, I would also appreciate it.

Jan

|||I would guess that you have a significant number of merged cells in your generated report, due to alignment issues in the RDL. Excel has known issues when loading a spreadsheet with many merge cells. The Excel Export in RS uses merged cells to maintain the layout defined in RDL, and if you have many rows, this can result in large numbers of merged cells.

Check out Chris's blog entry on merging cells and how to reduce them:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx|||

interesting...thanks for the answer

but there are no merged columns in my problematic excel file...and how is it possible that after copy-paste as values of the whole sheet becomes the opening and working with the excel file non-problematic...?

Backups

What's the difference between 'Online' and 'Offline'
backups in SQL 2000? Is it just that the SQL Server
services are stopped during an Offline BU?Hi,
Yes, you are correct. During offline backup we need to stop SQL Server
service and copy .MDF and .LDF files to a different location. We need to
ensure that we copy even the files belongs to system databases for faster
recovary.
Thanks
Hari
MCDBA
"ja
ydee" <anonymous@.discussions.microsoft.com> wrote in message
news:06a401c3b87f$08227860$a301280a@.phx.gbl...
> What's the difference between 'Online' and 'Offline'
> backups in SQL 2000? Is it just that the SQL Server
> services are stopped during an Offline BU?