MS SQL Server Tools - Backup/Restore MSSQL database from domain host?

Author

Backup/Restore MSSQL database from domain host?

Noozer

2006-03-21, 3:30 am

My domain host provides Windows hosting, including MS SQL database.
Unfortunately it doesn't provide remote connections to their MS SQL server.
I can see no method of retrieving my database structure, or the database
populated with data, from the hosts control panel.

I'm sure that I could upload a script to my webspace that would allow me to
download and upload my database structures and data, but I have no idea
where to find a script that would allow this.

I'm hoping to be able to develop the database locally, then upload the
changes to the online database. Later I'd like to be able to download the
database to make modifications or just farm the data within them.

Any ideas?

Tibor Karaszi

2006-03-21, 3:30 am

You need to ask your provider this. If they don't have a story on how you can backup and get the
database and also upload such a backup, then change provider.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Noozer" <dont.spam@me.here> wrote in message news:buMTf.164960$H%4.121289@pd7tw2no...
> My domain host provides Windows hosting, including MS SQL database. Unfortunately it doesn't
> provide remote connections to their MS SQL server. I can see no method of retrieving my database
> structure, or the database populated with data, from the hosts control panel.
>
> I'm sure that I could upload a script to my webspace that would allow me to download and upload my
> database structures and data, but I have no idea where to find a script that would allow this.
>
> I'm hoping to be able to develop the database locally, then upload the changes to the online
> database. Later I'd like to be able to download the database to make modifications or just farm
> the data within them.
>
> Any ideas?
>

Sponsored Links