Friday, September 6, 2013

How to backup remote SQL Server database to local drive?

See this MSDN article, for the section on backing up to a network share,

e.g.:

BACKUP DATABASE YourDatabase
   TO DISK = '\\SomeMachine\Backups\YourDatabase.Bak';

No comments: