Sunday, March 25, 2012

backing up DTS packages stored on a SQL Server

How do I do that?
Then how do I restored them?
Thanks!
DanutThis is a multi-part message in MIME format.
--=_NextPart_000_0332_01C35132.9804EC60
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
They are stored in the msdb database. Backing it up backs up the =packages. Restore it and you restore the packages.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Danut" <danutzp1@.hotmail.com> wrote in message =news:OKvB1LVUDHA.2020@.TK2MSFTNGP11.phx.gbl...
How do I do that?
Then how do I restored them?
Thanks!
Danut
--=_NextPart_000_0332_01C35132.9804EC60
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

They are stored in the msdb =database. Backing it up backs up the packages. Restore it and you restore =the packages.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Danut" wrote =in message news:OKvB1LVUDHA.2020=@.TK2MSFTNGP11.phx.gbl...How do I do that?Then how do I restored them?Thanks!Danut

--=_NextPart_000_0332_01C35132.9804EC60--|||Danut,
See
Backing Up Packages
http://www.sqldts.com/default.aspx?6,105,202,0,1
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Danut" <danutzp1@.hotmail.com> wrote in message
news:OKvB1LVUDHA.2020@.TK2MSFTNGP11.phx.gbl...
> How do I do that?
> Then how do I restored them?
> Thanks!
> Danut
>|||Thanks Tom!
Thanks Dinesh!
Danut
"Danut" <danutzp1@.hotmail.com> wrote in message
news:OKvB1LVUDHA.2020@.TK2MSFTNGP11.phx.gbl...
> How do I do that?
> Then how do I restored them?
> Thanks!
> Danut
>

No comments:

Post a Comment