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.

 All Forums
 General SQL Server Forums
 Script Library
 Backup from a webserver

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 thanks

Drew

Thanks

Drew

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
Go to Top of Page

drewsalem
Constraint Violating Yak Guru

304 Posts

Posted - 2006-09-28 : 05:38:49
Ha ha! Sorry.



Thanks

Drew
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -