Estimation of Backup Time

Any idea, how to calculate estimated time for a DB Backup?
Kind regards
Khurram ShahzadHi
It is very dependent on your hardware and Server Load.
You are going to have to test it yourself.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Khurram Shahzad" wrote:

> Any idea, how to calculate estimated time for a DB Backup?
> Kind regards
> Khurram Shahzad
>
>
>sql

Estimation of Backup Time

Any idea, how to calculate estimated time for a DB Backup?
Kind regards
Khurram Shahzad
Hi
It is very dependent on your Hardware and Server Load.
You are going to have to test it yourself.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Khurram Shahzad" wrote:

> Any idea, how to calculate estimated time for a DB Backup?
> Kind regards
> Khurram Shahzad
>
>
>

Estimation of Backup Time

Any idea, how to calculate estimated time for a DB Backup?
Kind regards
Khurram ShahzadHi
It is very dependent on your Hardware and Server Load.
You are going to have to test it yourself.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Khurram Shahzad" wrote:
> Any idea, how to calculate estimated time for a DB Backup?
> Kind regards
> Khurram Shahzad
>
>
>

Error: Subreport could not be shown.

Does anyone have an idea what would cause this error when viewing this in
Report Manager or thru a subscription to be rendered as a PDF attachment?
Subreports view fine through Visual Studio .NET Report project.
Thanks in advance.whats the error u r getting?
"Microsoft PrivateNews" <Dave.Troyer@.cliftoncpa.com> wrote in message news:<uRRh35dwEHA.1524@.TK2MSFTNGP09.phx.gbl>...
> Does anyone have an idea what would cause this error when viewing this in
> Report Manager or thru a subscription to be rendered as a PDF attachment?
> Subreports view fine through Visual Studio .NET Report project.
> Thanks in advance.|||I figured out the problem. In report manager, the error displayed was
'Error: Subreport could not be shown.' What happen was when I uploaded the
reports thru report manager and then change the name of the reports in
report manager. The subreport could not be found that was specified
originally.
Thanks for replying.
"Amit Bhandari" <abhandari2004@.gmail.com> wrote in message
news:c3d1e67b.0411041027.63b0acf4@.posting.google.com...
> whats the error u r getting?
>
> "Microsoft PrivateNews" <Dave.Troyer@.cliftoncpa.com> wrote in message
> news:<uRRh35dwEHA.1524@.TK2MSFTNGP09.phx.gbl>...
>> Does anyone have an idea what would cause this error when viewing this in
>> Report Manager or thru a subscription to be rendered as a PDF attachment?
>> Subreports view fine through Visual Studio .NET Report project.
>> Thanks in advance.

Error: Subreport could not be shown

I am getting this error when I run this report only when I access this report
from my PC. When I run it on the server it works fine. Any idea.
ThanksOn Jun 13, 11:14 am, Shan <S...@.discussions.microsoft.com> wrote:
> I am getting this error when I run this report only when I access this report
> from my PC. When I run it on the server it works fine. Any idea.
> Thanks
Is the subreport located in the correct location on your PC? Also,
sometimes this error occurs when there is an error in the subreport.
Is there maybe some missing data/stored procedure/etc on your local
machine that does exist on the other machine/server? Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks for the tip. But all of a sudden it's working now. I dint' do any
thing. I dont know why wouldn't it run I never had this issue before. Thanks
"EMartinez" wrote:
> On Jun 13, 11:14 am, Shan <S...@.discussions.microsoft.com> wrote:
> > I am getting this error when I run this report only when I access this report
> > from my PC. When I run it on the server it works fine. Any idea.
> > Thanks
> Is the subreport located in the correct location on your PC? Also,
> sometimes this error occurs when there is an error in the subreport.
> Is there maybe some missing data/stored procedure/etc on your local
> machine that does exist on the other machine/server? Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 13, 1:32 pm, Shan <S...@.discussions.microsoft.com> wrote:
> Thanks for the tip. But all of a sudden it's working now. I dint' do any
> thing. I dont know why wouldn't it run I never had this issue before. Thanks
> "EMartinez" wrote:
> > On Jun 13, 11:14 am, Shan <S...@.discussions.microsoft.com> wrote:
> > > I am getting this error when I run this report only when I access this report
> > > from my PC. When I run it on the server it works fine. Any idea.
> > > Thanks
> > Is the subreport located in the correct location on your PC? Also,
> > sometimes this error occurs when there is an error in the subreport.
> > Is there maybe some missing data/stored procedure/etc on your local
> > machine that does exist on the other machine/server? Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I'm glad it works now. In this case, I would suggest checking the
query/stored procedure that is sourcing the subreport to make sure
that it does not have performance problems (probably via the Database
Engine Tuning Advisor). Also, check the report using a full range of
parameter values (where applicable) to verify that you did not omit
the error by parameter selection. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant