SQL Server 2008 remote backup

we use shared hosting and shared SS2008 for our clients, developing online and using SSMSE to manage the databases. although we're very happy with our hosts, and the backups they provide, we now have a situation where one client wants to have additional external backups of their data to disaster-proof them.

any ideas how we can do this? i've used DTS before - but i understand that instead there's now SSIS, which i think is not provided with the developer edition of SS2008?

all the versions of SS2008 confuse me; i just want something cheap and cheerful that will do the job.

more ▼

asked May 14, 2010 at 06:08 AM in Default

favedish gravatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Please correct me if I am wrong , you are thinking to take the backup in a remote PC other than the Server.

am I right ?

more ▼

answered Jun 01, 2010 at 07:03 AM

Manish 1 1 gravatar image

Manish 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 14, 2010 at 06:08 AM

Seen: 1984 times

Last Updated: May 14, 2010 at 06:08 AM