Automatically copying tables to a backup question...

Folks,
Hope you can help with this one please. I want to regulary copy the
contents of a particular table in a database to another database server
with an identical setup.
My question is: does SQL Server 2000 have the ability to do this
automatically?
Any comments/suggestions/user-experiences/things to watch out for
would me most appreciated.
Cheers,
Al.almurph@.altavista.com wrote:
> Folks,
>
> Hope you can help with this one please. I want to regulary copy the
> contents of a particular table in a database to another database server
> with an identical setup.
> My question is: does SQL Server 2000 have the ability to do this
> automatically?
> Any comments/suggestions/user-experiences/things to watch out for
> would me most appreciated.
> Cheers,
> Al.
DTS will be best option for this.
You can create a DTS Package and schedule it.
Look in BOL for more details.
Regards
Amish Shah
http://shahamishm.tripod.com|||almurph@.altavista.com wrote:
> Folks,
>
> Hope you can help with this one please. I want to regulary copy the
> contents of a particular table in a database to another database server
> with an identical setup.
> My question is: does SQL Server 2000 have the ability to do this
> automatically?
> Any comments/suggestions/user-experiences/things to watch out for
> would me most appreciated.
> Cheers,
> Al.
>
There are several options available to you:
- replication
- DTS
- a simple INSERT/SELECT over a linked server
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Automatically copying tables to a backup question...

Folks,
Hope you can help with this one please. I want to regulary copy the
contents of a particular table in a database to another database server
with an identical setup.
My question is: does SQL Server 2000 have the ability to do this
automatically?
Any comments/suggestions/user-experiences/things to watch out for
would me most appreciated.
Cheers,
Al.almurph@.altavista.com wrote:

> Folks,
>
> Hope you can help with this one please. I want to regulary copy the
> contents of a particular table in a database to another database server
> with an identical setup.
> My question is: does SQL Server 2000 have the ability to do this
> automatically?
> Any comments/suggestions/user-experiences/things to watch out for
> would me most appreciated.
> Cheers,
> Al.
DTS will be best option for this.
You can create a DTS Package and schedule it.
Look in BOL for more details.
Regards
Amish Shah
http://shahamishm.tripod.com|||almurph@.altavista.com wrote:
> Folks,
>
> Hope you can help with this one please. I want to regulary copy the
> contents of a particular table in a database to another database server
> with an identical setup.
> My question is: does SQL Server 2000 have the ability to do this
> automatically?
> Any comments/suggestions/user-experiences/things to watch out for
> would me most appreciated.
> Cheers,
> Al.
>
There are several options available to you:
- replication
- DTS
- a simple INSERT/SELECT over a linked server
Tracy McKibben
MCDBA
http://www.realsqlguy.comsql

Automatic PDF/TIFF generation and saving?

Ello folks...
Question for you all - I'd like to make a call from a webpage (asp or aspx)
that will call up a report with a given set of parameters, format it as a pdf
or tiff file, and save it to a location. Any ideas?
I know I can use the /ReportServer/ instance to directly call the report,
pass it the parameters I need, and render it out as a different format, but
it's the saving part that's throwing me.
Thanks!
- TerosTeros,
How about a subscription instead, or does it have to be on request?
A subscription can do this for you, but rendering on demand will always
ask.
Sorry, I don't think it can be done.
Chris
Teros wrote:
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or
> aspx) that will call up a report with a given set of parameters,
> format it as a pdf or tiff file, and save it to a location. Any
> ideas?
> I know I can use the ReportServer instance to directly call the
> report, pass it the parameters I need, and render it out as a
> different format, but it's the saving part that's throwing me.
> Thanks!
> - Teros|||I have seen someone say you can save the output stream as a file . I looked
for a previous post but didn;t find it.
The other way is to create a data-based subscription... in the subscription
row you can choose the filename and path...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Teros" <Teros@.discussions.microsoft.com> wrote in message
news:1BCA0EE4-E9B9-4BE9-8F35-55A0EB09FD96@.microsoft.com...
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or
> aspx)
> that will call up a report with a given set of parameters, format it as a
> pdf
> or tiff file, and save it to a location. Any ideas?
> I know I can use the /ReportServer/ instance to directly call the report,
> pass it the parameters I need, and render it out as a different format,
> but
> it's the saving part that's throwing me.
> Thanks!
> - Teros|||Check out the web method - RenderStream - you can render to a stream then
save the stream to a file
"Teros" wrote:
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or aspx)
> that will call up a report with a given set of parameters, format it as a pdf
> or tiff file, and save it to a location. Any ideas?
> I know I can use the /ReportServer/ instance to directly call the report,
> pass it the parameters I need, and render it out as a different format, but
> it's the saving part that's throwing me.
> Thanks!
> - Teros|||Teros,
AFAIK there is no way to do this from URL access. We do what you're doing
by calling the web service and saving the stream off to a file.
Ted
"Teros" wrote:
> Ello folks...
> Question for you all - I'd like to make a call from a webpage (asp or aspx)
> that will call up a report with a given set of parameters, format it as a pdf
> or tiff file, and save it to a location. Any ideas?
> I know I can use the /ReportServer/ instance to directly call the report,
> pass it the parameters I need, and render it out as a different format, but
> it's the saving part that's throwing me.
> Thanks!
> - Teros|||Thanks for the input - the report does need to be rendered on demand, so the
subscriptions wouldn't work. I'm playing with the renderstream now to see
what I can play with. It's looking pretty hopeful thus far.
Thanks!|||For PDF or TIFF files, you use the Render() method. RenderStream is used for
things like images on an HTML page.
Ted
"Mary Bray [SQL Server MVP]" wrote:
> Check out the web method - RenderStream - you can render to a stream then
> save the stream to a file
> "Teros" wrote:
> > Ello folks...
> >
> > Question for you all - I'd like to make a call from a webpage (asp or aspx)
> > that will call up a report with a given set of parameters, format it as a pdf
> > or tiff file, and save it to a location. Any ideas?
> >
> > I know I can use the /ReportServer/ instance to directly call the report,
> > pass it the parameters I need, and render it out as a different format, but
> > it's the saving part that's throwing me.
> >
> > Thanks!
> > - Teros|||Any luck Teros? I'm trying to do the same thing (I think). We have a report
that will be called from a third party application, and when it is called we
want it to create a pdf to a specific location, and then close. I'd be very
interested in knowing how you did it.
Michael C.
"Teros" wrote:
> Thanks for the input - the report does need to be rendered on demand, so the
> subscriptions wouldn't work. I'm playing with the renderstream now to see
> what I can play with. It's looking pretty hopeful thus far.
> Thanks!
>

Autogrow question

Hello Folks,

Last evening, as a result of our autogrow settings, our production
database grew from 102 GB to 107 GB. What puzzled me is that, prior to
the growth, we still had a good 10% free space left in the data file.
My understanding is that SQL Server will automatically grow a database
when worker thread decides that more space is necessary to fulfill a
request. We don't suspect the app of sending over a request which
would require that much more space.

Any ideas on why the file grew unexpectedly?

Thanks,
JoeHi

Although everywhere I have found regarding filegrowth indicates it is done
when the file is full, it would make sense that it is grown before it is
actually totally full otherwise you will have problems on a highly active
system!!!

You can still have problems if the file growth is set to very large values
even if the disc space is available as the time to fill up the remainder of
the file may be less than the time taken to grow it.

John

"ceadtinneh" <sulla33@.yahoo.com> wrote in message
news:1128023665.503904.262830@.z14g2000cwz.googlegr oups.com...
> Hello Folks,
> Last evening, as a result of our autogrow settings, our production
> database grew from 102 GB to 107 GB. What puzzled me is that, prior to
> the growth, we still had a good 10% free space left in the data file.
> My understanding is that SQL Server will automatically grow a database
> when worker thread decides that more space is necessary to fulfill a
> request. We don't suspect the app of sending over a request which
> would require that much more space.
> Any ideas on why the file grew unexpectedly?
> Thanks,
> Joe