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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2006-09-28 : 05:18:03
|
| Hi,I have a .Net website being served by my provider from Server A. It stores data in SQL Server B. Two seperate machines.I have access to server A, but limited access to server B. Is there a script I can put on server A that will backup the database on SQL Server B and save it to a drive on server A (or even better my local drive).Many thanksDrewThanksDrew |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-28 : 05:32:02
|
| If Server B has a share, or permissions, to access the drives on Server A - or your PC - then yes, otherwise no.(This forum is for posting fully formed scripts, rather than questions, and I click on this topic hoping you had a fully worked solution to this problem! Drat!)Kristen |
 |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-09-28 : 05:38:49
|
| Ha ha! Sorry.ThanksDrew |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2006-10-19 : 18:33:17
|
| Kristen,Maybe this can be of some use here?http://sqlteam.com/forums/topic.asp?TOPIC_ID=73608"... It generates a single SQL script file which can be used to recreate a database (both schema and data) in a shared hosting environment where the only connectivity to a server is through a web-based control panel with a script execution window."Could consider that script a backup? hmm, naybe a stretch...Nathan Skerl |
|
|
|
|
|
|
Backup from a webserver