can i schedule a database restore from a DTS package??

if so, what task do i use??

tia

jt

Hi,

For scheduling restores, use the SQL Agent to schedule a Job.

Steps.

1. Open enterprise manager
2. Expand server and select Management
3. Select SQL Agent and expand
4. Select job
5. right click and new job....

Thanks
Hari
MCDBA

Thanks
Hari
MCDBA

"JT" <anonymous (AT) discussions (DOT) microsoft.com> wrote

You can but I wouldn't.

There is no point in using DTS

Use a SQL Server Agent Job. A Transact SQL Job step - Issue the RESTORE
command


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"JT" <anonymous (AT) discussions (DOT) microsoft.com> wrote