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 |
|
montyfintan
Starting Member
4 Posts |
 Posted - 2008-05-13 : 07:41:33
|
| HiI have a SQL db with a hosting company that appears to have gone bust, so am moving my site from them to a new provider. I am able to access the database on the SQL server but I need to transfer all the data and objects to my desktop PC. I have tried scripting all data/objects and DTS but these just generate errors and fail (I suspect due to permissions).I did this once before and got a .bak file from the providers, which I was successfully able to restore elsewhere, so this is what I need to do again. However, now I'm getting no response to support requests so need to do this myself. The question, then is....Is there a way to backup a SQL db to a .bak file on the server and then somehow transfer it to my own machine? Or is it possible to somehow run the backup to a different machine and get it off their server?Any help would be appreciated, as I'm worried about how long I'll continue to have access to the server before they all disappear without a trace! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 12:04:20
|
| "Is there a way to backup a SQL db to a .bak file on the server and then somehow transfer it to my own machine?"Yes you can. |
 |
|
|
montyfintan
Starting Member
4 Posts |
Posted - 2008-05-13 : 12:13:52
|
| Thanks for shred of hope. Any chance of some advice on the best way to do it? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-13 : 12:16:25
|
| You need to permission to backup . Tell you DBA to do . |
|
|
|
montyfintan
Starting Member
4 Posts |
Posted - 2008-05-13 : 12:29:25
|
| Unfortunately that's where I have the problem. I appear able to do the backup, but the .bak file will only save on the server and I have no way of 'getting to it'. The DBA - along with any other staff or tech support from the host, have been un-contactable for the last three weeks and I believe the company is closing down, leaving me in the lurch. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:19:38
|
| Can you get backup file with ftp? |
|
|
|
|
|
|
Backing up SQL db to a remote machine