Backup remote SQL Server 2005

Question

How do I backup data from a remote MS-SQL Server DB to my local computer?

I'm having access to Management Studio 2008.

Answer 1

You'd specify the target for the backup file to a UNC path on your local machine. When you specify to Backup you have to specify a Desination. That destination can be either a Filename locally pathed to the SQL Server instance (e.g. E:\Backups\Database.BAK) or a UNC path such as \\YOURMACHINENAME\SHAREDFOLDERONYOURMACHINE\FILENAME.BAK.

Answer 2

If you want to backup the remote database then you can run a query such as

BACKUP DATABASE mydb TO DISK = 'd:\whatever\location\mydb.bak'

Where the 'd:' drive will be local to the SQL Server, otherwise use the format

BACKUP DATABASE mydb TO DISK = '\\mylocalcomputer\share\mydb.bak'

to backup to your machine.

Answer 3

sqldumper.ruizata.com solved my problem.