CODEWITHSUNDEEP
sqlsql-serverdatabasebackup
stulster
stulster

Reputation: 137

Backup remote SQL Server 2005

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

I'm having access to Management Studio 2008.

Upvotes: 3

Views: 3971

Answers (3)

stulster
stulster

Reputation: 137

sqldumper.ruizata.com solved my problem.

Upvotes: 3

Miles D
Miles D

Reputation: 8040

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.

Upvotes: 1

Keith Adler
Keith Adler

Reputation: 21178

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.

Upvotes: 2

Related Questions