Database backup process

My database is on a hired shared server, where the use of BACKUP DATABASE is
prohibited.
Therefore I need to copy the database to my own server using DTS - does DTS
have a different name in SQL Server 2005? - and then run BACKUP DATABASE to
make a .bak file that I can backup elsewhere to provide belt and braces.
What is the cheapest version of SQL Server 2005 that has DTS? Express,
which is free, appears not to have it; does the Developer version have it?
Or to I have to buy the Standard Edition at great expense?
Thanking you in anticipation for your advice.
RogerIf you can not use BACKUP then try the Copy Database Wizard instead.
Right-click your database, select Tasks, copy Database ...
Hope this helps,
Ben Nevarez
"Roger Withnell" wrote:
> My database is on a hired shared server, where the use of BACKUP DATABASE is
> prohibited.
> Therefore I need to copy the database to my own server using DTS - does DTS
> have a different name in SQL Server 2005? - and then run BACKUP DATABASE to
> make a .bak file that I can backup elsewhere to provide belt and braces.
> What is the cheapest version of SQL Server 2005 that has DTS? Express,
> which is free, appears not to have it; does the Developer version have it?
> Or to I have to buy the Standard Edition at great expense?
> Thanking you in anticipation for your advice.
> Roger
>|||> Therefore I need to copy the database to my own server using DTS - does DTS
> have a different name in SQL Server 2005?
Yes, SQL Server Integration Services, aka Integration Services, aka IS, aka SSIS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Roger Withnell" <RogerWithnell@.discussions.microsoft.com> wrote in message
news:A3F285D1-60C2-4BE6-AC62-6FFBBDA7806B@.microsoft.com...
> My database is on a hired shared server, where the use of BACKUP DATABASE is
> prohibited.
> Therefore I need to copy the database to my own server using DTS - does DTS
> have a different name in SQL Server 2005? - and then run BACKUP DATABASE to
> make a .bak file that I can backup elsewhere to provide belt and braces.
> What is the cheapest version of SQL Server 2005 that has DTS? Express,
> which is free, appears not to have it; does the Developer version have it?
> Or to I have to buy the Standard Edition at great expense?
> Thanking you in anticipation for your advice.
> Roger
>