Database backup process

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Withnell - 07 Mar 2008 23:00 GMT

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

Reply to this Message

Ben Nevarez - 07 Mar 2008 23:20 GMT

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

> My database is on a hired shared server, where the use of BACKUP DATABASE is
> prohibited.
[quoted text clipped - 10 lines]
>
> Roger

Reply to this Message

Tibor Karaszi - 08 Mar 2008 19:21 GMT

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

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> My database is on a hired shared server, where the use of BACKUP DATABASE is
> prohibited.
[quoted text clipped - 10 lines]
>
> Roger

Reply to this Message