What's the total number of "y"s in:
Q: Backing up an online database I havea 70MB db of my website which is hosted with a provider. I am able to access my db using SSMS 2008 remotely.
On a running website, which is the best way I can back up the db locally on machine
Thanks

A: You always use BACKUP DATABASE for backups, but this will only go the local volumes (drives, SAN etc) or a network share.
Your question is unclear though:


*

*Your SSMS access if after remote access onto their machine: not from your local machine?

*Do you mean "backup to my local machine"?


If you can access the remote SQL Instance from your local machine, I'd say change hosting provider now. If you want a backup stored locally on your machine, then you'd need to have a file connection between here and there.
Edit:
Use tools like Red Gate SQL Compare and Data Compare to create a copy on your local machine if you can access the DB. You won't be able to backup to file over the internet (I hope.)
This also means your SQL Server instance is exposed on the internet which is a bad thing generally which is why I said change providers.
And yes, the web site can stay running.

A: There are two tools you can use to do the job remotely:


*

*DDLUtils

*SQL workbench
Neither of them can generate a valid SQL Server backup, but they can transfer data and  schemas between databases over the network. Additionally, both tools have the following features:


*

*platform independent, will work anywhere Java runs

*scriptable (can be scheduled etc.)

*database-independent, to a large degree, supporting a wide variety of DB systems

*cross-database support: mirror a database from mssql to postgresql to oracle to mysql...

*free and open source


and limitations:


*

*they might have limited support for stored procedures, triggers and other DB code: they are mostly focused on data and data structures

*might require some hand tweaking to work (something might be a keyword in one database system, but not in another so it has to be treated differently etc.)

*you need a local SQL server instance as a target to which data will be copied


Having said that, it is really mind-boggling that in 2010 there exists a relational DB system which doesn't provide a way to execute an over-the-network backup and will not work on anything other than Windows. And is relatively widely used.

A: backup database MyDB to disk=' .... '
where .... - path on SQL Server (provided by your hosting provider). This path must be accessed by HTTP or FTP.

user
There are fifty-four "y"s in the text you provided.
assistant