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';

You May Also Like

0 comments