2

I have a SQL Server 2008 database that is hosted by a third party host (heart internet). How would I go about backing this up?

I used SQL Server Management Studio Express 2008 to create the tables within the database, but the backup options within this app seem to be only of use if you have direct access to the server machine (which I don't)

It's also worth noting that I am using change tracking - I presume this data would be lost should any backup be restored?

Thanks In Advance!

(PS - SQL Server 2008 novice here!)

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Sergio
  • 9,761
  • 16
  • 60
  • 88

2 Answers2

1

If they allow you to run backups to a particular folder that you have access to you can just do it with the regular backup command:

backup database dbname to disk = 'y:\users\YourHomePath'

If they do not do that you might want to use the Database Publishing Wizard to script out your database (depending on the size this might be very slow)

My Other Me
  • 5,007
  • 6
  • 41
  • 48
  • Hmmm, came across the documentation on their site - looks like they only support using the database publishing wizard. https://customer.heartinternet.co.uk/manage/support.cgi?action=view_question;question_id=714 I guess this is going to be very slow (around 1 million rows). Doesn't really seem like a very good backup procedure to me :( hopefully im wrong – Sergio Jan 22 '10 at 09:15
  • Just noticed that the database publishing wizard does not work on SQL Server 2008... – Sergio Jan 22 '10 at 09:25
  • Depending on what SQL tools/editions you have installed you might look for the following: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe. That MIGHT allow you to do some transfers at faster rates, but will be a lot harder to micro-manage at the end of the day. – My Other Me Jan 22 '10 at 16:59
  • And according to http://technet.microsoft.com/en-us/library/bb895179.aspx you can connect to SQL 2008... – My Other Me Jan 22 '10 at 17:01
0

You can create a .DAT file into a shared disk and to download it through FTP.

Rubens Farias
  • 57,174
  • 8
  • 131
  • 162