I'm sure this will have already been asked on this forum but to save some
searching.... My hosting company (fasthosts) does not allow database backups
using the standard Management> Backup. Instead, they say use DTS to backup.

Has anyone any idea on how this is done, as I have never used DTS before?

Thanks in advance,
Mike

You can build a DTS package that transfers all your SQL Server objects to
A.N.Other server and this is to what I think they are referring. In 2000
you also have a Transfer Database task which would do your job as well.

You can do the "Copy SQL Server objects" using the Wizard or you can do it
using the Designer. The Transfer Database task is only available in the
designer though.

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)



--

----------------------------

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


"Mike" <mike (AT) thegeorgesons (DOT) co.uk> wrote