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).
"... 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...