Question about restoring a database

All,
I have many DTS packages pulling data from production
servers to reporting servers. This is going to be changed
so that the production servers push the data to the
reporting servers.
The production server DBA wants to periodically make a
full backup of the databases, "zip" them, and FTP them to
the reporting servers. On the reporting servers, the "zip"
files will be un-zipped and the databases will be
restored. The databases are scattered over half the US.
Most of the tables, triggers, stored procedures, views,
users, etc. in the copied databases are not needed for our
reporting. I would like to be able to drop these objects
from the reporting server databases immediately after they
are restored. Doing so will free up significant amounts of
hard drive space.
My biggest concern is that dropping objects from a
database will cause problems when attempting a restore? Is
this concern valid?
TIA,
Mike> My biggest concern is that dropping objects from a
> database will cause problems when attempting a restore? Is
> this concern valid?
You mean that next time you will restore the database? No, that will not
cause problems. One thing, though. Top free up space after dropping the
object you need to shrink the files. Because of this, before the next
restore, you either need to delete the database first, or use the REPLACE
parameter in the RESTORE command.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:057001c3a97b$cec6ea40$a401280a@.phx.gbl...
> All,
> I have many DTS packages pulling data from production
> servers to reporting servers. This is going to be changed
> so that the production servers push the data to the
> reporting servers.
> The production server DBA wants to periodically make a
> full backup of the databases, "zip" them, and FTP them to
> the reporting servers. On the reporting servers, the "zip"
> files will be un-zipped and the databases will be
> restored. The databases are scattered over half the US.
> Most of the tables, triggers, stored procedures, views,
> users, etc. in the copied databases are not needed for our
> reporting. I would like to be able to drop these objects
> from the reporting server databases immediately after they
> are restored. Doing so will free up significant amounts of
> hard drive space.
> My biggest concern is that dropping objects from a
> database will cause problems when attempting a restore? Is
> this concern valid?
> TIA,
> Mike
>
>sql

Question about deploying DTS objects (COM, DTSRUN.exe, etc.).

Hello all!
I have a series of file-based DTS packages that I want to execute from our
web servers, and I have a couple of questions about the deployment of the
objects necessary to support these packages.
In my DTS packages, I have some ActiveX scripts that do some "package
manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
DTS COM objects to be installed and registered on the web servers?
Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
servers, so I'd probably need to install that (and any dependencies?) on the
Web servers.
I'm not really sure which files I need, or where to start looking. Are
there any licensing issues involved with having the DTS components on our
production web servers?
I'd be grateful for any assistance anyone can provide! :-)
John PetersonThis article is helpful
Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hello all!
> I have a series of file-based DTS packages that I want to execute from our
> web servers, and I have a couple of questions about the deployment of the
> objects necessary to support these packages.
> In my DTS packages, I have some ActiveX scripts that do some "package
> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
> DTS COM objects to be installed and registered on the web servers?
> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
> servers, so I'd probably need to install that (and any dependencies?) on
> the Web servers.
> I'm not really sure which files I need, or where to start looking. Are
> there any licensing issues involved with having the DTS components on our
> production web servers?
> I'd be grateful for any assistance anyone can provide! :-)
> John Peterson
>|||Thanks Allan! I had *just* chanced upon that link when you replied. :-)
I notice that there's no mention of any licensing issues. Do you have any
suggestions regarding that?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
> This article is helpful
> Redistributing DTS with your program
> (http://www.sqldts.com/default.aspx?225)
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>|||Licencing - yuck.
Have a look in redist.txt.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:ubodiFTbFHA.1148@.tk2msftngp13.phx.gbl...
> Thanks Allan! I had *just* chanced upon that link when you replied. :-)
> I notice that there's no mention of any licensing issues. Do you have any
> suggestions regarding that?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
>

Question about deploying DTS objects (COM, DTSRUN.exe, etc.).

Hello all!
I have a series of file-based DTS packages that I want to execute from our
web servers, and I have a couple of questions about the deployment of the
objects necessary to support these packages.
In my DTS packages, I have some ActiveX scripts that do some "package
manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
DTS COM objects to be installed and registered on the web servers?
Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
servers, so I'd probably need to install that (and any dependencies?) on the
Web servers.
I'm not really sure which files I need, or where to start looking. Are
there any licensing issues involved with having the DTS components on our
production web servers?
I'd be grateful for any assistance anyone can provide! :-)
John PetersonThis article is helpful
Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hello all!
> I have a series of file-based DTS packages that I want to execute from our
> web servers, and I have a couple of questions about the deployment of the
> objects necessary to support these packages.
> In my DTS packages, I have some ActiveX scripts that do some "package
> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
> DTS COM objects to be installed and registered on the web servers?
> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
> servers, so I'd probably need to install that (and any dependencies?) on
> the Web servers.
> I'm not really sure which files I need, or where to start looking. Are
> there any licensing issues involved with having the DTS components on our
> production web servers?
> I'd be grateful for any assistance anyone can provide! :-)
> John Peterson
>|||Thanks Allan! I had *just* chanced upon that link when you replied. :-)
I notice that there's no mention of any licensing issues. Do you have any
suggestions regarding that?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
> This article is helpful
> Redistributing DTS with your program
> (http://www.sqldts.com/default.aspx?225)
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> Hello all!
>> I have a series of file-based DTS packages that I want to execute from
>> our web servers, and I have a couple of questions about the deployment of
>> the objects necessary to support these packages.
>> In my DTS packages, I have some ActiveX scripts that do some "package
>> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need
>> the DTS COM objects to be installed and registered on the web servers?
>> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
>> servers, so I'd probably need to install that (and any dependencies?) on
>> the Web servers.
>> I'm not really sure which files I need, or where to start looking. Are
>> there any licensing issues involved with having the DTS components on our
>> production web servers?
>> I'd be grateful for any assistance anyone can provide! :-)
>> John Peterson
>>
>|||Licencing - yuck.
Have a look in redist.txt.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:ubodiFTbFHA.1148@.tk2msftngp13.phx.gbl...
> Thanks Allan! I had *just* chanced upon that link when you replied. :-)
> I notice that there's no mention of any licensing issues. Do you have any
> suggestions regarding that?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
>> This article is helpful
>> Redistributing DTS with your program
>> (http://www.sqldts.com/default.aspx?225)
>> --
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.SQLIS.com - You thought DTS was good. here we show you the new
>> stuff.
>> www.konesans.com - Consultancy from the people who know
>>
>> "John Peterson" <j0hnp@.comcast.net> wrote in message
>> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> Hello all!
>> I have a series of file-based DTS packages that I want to execute from
>> our web servers, and I have a couple of questions about the deployment
>> of the objects necessary to support these packages.
>> In my DTS packages, I have some ActiveX scripts that do some "package
>> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need
>> the DTS COM objects to be installed and registered on the web servers?
>> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
>> servers, so I'd probably need to install that (and any dependencies?) on
>> the Web servers.
>> I'm not really sure which files I need, or where to start looking. Are
>> there any licensing issues involved with having the DTS components on
>> our production web servers?
>> I'd be grateful for any assistance anyone can provide! :-)
>> John Peterson
>>
>>
>

Question about deploying DTS objects (COM, DTSRUN.exe, etc.).

Hello all!
I have a series of file-based DTS packages that I want to execute from our
web servers, and I have a couple of questions about the deployment of the
objects necessary to support these packages.
In my DTS packages, I have some ActiveX scripts that do some "package
manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
DTS COM objects to be installed and registered on the web servers?
Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
servers, so I'd probably need to install that (and any dependencies?) on the
Web servers.
I'm not really sure which files I need, or where to start looking. Are
there any licensing issues involved with having the DTS components on our
production web servers?
I'd be grateful for any assistance anyone can provide! :-)
John Peterson
This article is helpful
Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hello all!
> I have a series of file-based DTS packages that I want to execute from our
> web servers, and I have a couple of questions about the deployment of the
> objects necessary to support these packages.
> In my DTS packages, I have some ActiveX scripts that do some "package
> manipulation" (enabling/disabling Steps, etc.). I'm guessing I'd need the
> DTS COM objects to be installed and registered on the web servers?
> Additionally, the DTS packages will be invoked by DTSRUN.exe on the Web
> servers, so I'd probably need to install that (and any dependencies?) on
> the Web servers.
> I'm not really sure which files I need, or where to start looking. Are
> there any licensing issues involved with having the DTS components on our
> production web servers?
> I'd be grateful for any assistance anyone can provide! :-)
> John Peterson
>
|||Thanks Allan! I had *just* chanced upon that link when you replied. :-)
I notice that there's no mention of any licensing issues. Do you have any
suggestions regarding that?
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
> This article is helpful
> Redistributing DTS with your program
> (http://www.sqldts.com/default.aspx?225)
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
> www.konesans.com - Consultancy from the people who know
>
> "John Peterson" <j0hnp@.comcast.net> wrote in message
> news:%23AymH4SbFHA.1404@.TK2MSFTNGP09.phx.gbl...
>
|||Licencing - yuck.
Have a look in redist.txt.
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:ubodiFTbFHA.1148@.tk2msftngp13.phx.gbl...
> Thanks Allan! I had *just* chanced upon that link when you replied. :-)
> I notice that there's no mention of any licensing issues. Do you have any
> suggestions regarding that?
>
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:OLzhPCTbFHA.3040@.TK2MSFTNGP14.phx.gbl...
>