Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2007-04-01 : 06:07:19
|
| I'm connecting Management Studio Express to my database on my ISP, I right click my database, Tasks-Backup.I am the dbo.I enter a local path in the Destination. Run the backup, I get a message "Backup created successfully", but when I look in the local folder, it is empty?? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-01 : 07:04:31
|
Backup will not backup to your local path. In your case, the backup actually is created in the local drive of your Server in your ISP
KH |
 |
|
|
silas2
Yak Posting Veteran
65 Posts |
Posted - 2007-04-01 : 10:21:28
|
| That's handy! What's the best way to bring data down over the web from an ISP?I tried the Publishing Wizard, it worked but was very slow, maybe just bulk insert queries into a local db? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-01 : 10:28:20
|
are you doing this on ad-hoc basis or on a periodic basis ?
KH |
|
|
|
silas2
Yak Posting Veteran
65 Posts |
Posted - 2007-04-01 : 10:56:28
|
| Both, I really need to automate it, but at the moment I'm trying to get the app live, so I'd really like a way of getting a data snapshot so I can "rewind" if some of the bulk data-changing processes I'm testing go wrong. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-02 : 02:28:50
|
Backup to a location on the ISP's server to which you have FTP permissions, and then FTP the backup file down to your PCIn my experience ISPs with shared SQL hosting are often unhelpful in this regard  Kristen |
|
|
|
silas2
Yak Posting Veteran
65 Posts |
Posted - 2007-04-02 : 05:18:40
|
| I see there are these utilities for doing this like bcp. If you were restricted away from the backup, which would you use for taking data down off the web? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-02 : 05:45:49
|
| On my Local Server I would try to create a Linked Server to the ISP's Server, and then use DTS - or probably a more fancy query that just pulled down the "New & Changed" recordsKristen |
|
|
|
|
|
|
|
|
Backup From ISP