Monday, March 19, 2012

How to take back up of DTS packages ?

Hi,
Is there any way to take backup of DTS packages ?
Thanks,I saved my DTS packages in SQL Server. So, if I go to DTS node I can see all
my packages.
If I restore msdb, will DTS packages reflect in my SQL server like it used
to be ?
Thanks
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1KadnQGCK_zo7u6iRVn-jw@.giganews.com...
> They are stored in MSDB. Backup MSDB.
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
> "Vgs" <generalofmine@.yahoo.com> wrote in message
> news:%23hFSe76gDHA.2292@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Is there any way to take backup of DTS packages ?
> >
> > Thanks,
> >
> >
>|||Your DTS Package saved in the msdb database, you need a
backup msdb database
>--Original Message--
>Hi,
>Is there any way to take backup of DTS packages ?
>Thanks,
>
>.
>|||Also checkout this utility
Backing Up Packages
(http://www.sqldts.com/default.aspx?202)
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:4p6dnWJ9t6iPkemiRVn-uA@.giganews.com...
> Yes. MSDB also contains your SQL Agent jobs, schedules, etc so these will
be
> restored as well.
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
> "Vgs" <generalofmine@.yahoo.com> wrote in message
> news:OdUHJT%23gDHA.1668@.TK2MSFTNGP12.phx.gbl...
> > I saved my DTS packages in SQL Server. So, if I go to DTS node I can see
> all
> > my packages.
> > If I restore msdb, will DTS packages reflect in my SQL server like it
> used
> > to be ?
> >
> > Thanks
> >
> >
> > "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> > news:1KadnQGCK_zo7u6iRVn-jw@.giganews.com...
> > > They are stored in MSDB. Backup MSDB.
> > >
> > > --
> > > David Portas
> > > --
> > > Please reply only to the newsgroup
> > > --
> > >
> > > "Vgs" <generalofmine@.yahoo.com> wrote in message
> > > news:%23hFSe76gDHA.2292@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > >
> > > > Is there any way to take backup of DTS packages ?
> > > >
> > > > Thanks,
> > > >
> > > >
> > >
> > >
> >
> >
>

No comments:

Post a Comment