Thursday, March 22, 2012

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.
Roger
If 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
>

No comments:

Post a Comment