Hello,

I am trying to backup the database on the remote server using my local SQLEM.Can I backup so that the backup db is store on my local workstation rather than on the server db folder?Is there a way to this?




Andy

Mhm, if you have a MySQL distribution installed on your workstation (all you need is the client libraries and mysqldump) then you could simply do:

mysqldump -u<yourusername> -p<yourpass> -h<server_addr> -ce <database_name>

If you want to dump multiple databases, use -B db1,db2,db3, etc.
For dumping ALL databases, simply add the -A parameter.

Hello,

thanks for the reply.

But what I mean is MS SQL database and not MYSQL database.



Andy

Sorry, didn't catch that. :rolleyes:
I did find some software that does that kinda stuff (e.g., RBackup (http://remote-backup.com)), but it costs $$.

Originally posted by andy18
I am trying to backup the database on the remote server using my local SQLEM.Can I backup so that the backup db is store on my local workstation rather than on the server db folder?

It depends on what type of access you have between your PC and the server. If you can create a VPN tunnel between your location and the server, then you can simply use shares and drive mappings. Set the backup to dump to a mapped drive.

If you don't have the ability or desire to go the VPN route, I'd suggest making it a two step process. Automate your SQL Server database dumps to flat file locally on the server, and then retrieve the dump file via your preferred method (FTP, etc).

Can you set SQL to backup to a mapped drive?

Originally posted by RackMy.com
Can you set SQL to backup to a mapped drive?

Yes, definitely. You would use syntax like this:
backup database db_name to disk='x:\path\db_name.bak' with init

That's for a quick and dirty backup. You could even create a dump device on a mapped drive and backup to it.