SQL Server Backup to a Remote Server

Question

Good Afternoon,

I realise there is a command:

BACKUP DATABASE [DB Name] TO DISK [PATH]

Is it possible too backup to a remote location? - E.G. the web server rather than the database server?

Many Thanks, Joel

Answer 1

Yes you can. http://msdn.microsoft.com/en-us/library/ms179313.aspx

Answer 2

Yes. Exactly the same syntax as the normal backup command, but replace the path as appropriate, eg:

BACKUP DATABASE [DB NAME] TO DISK [\\server\share\path]

There's an example on http://msdn.microsoft.com/en-us/library/ms179313.aspx that shows this.

You will need to make sure that the SQL server account is able to write files to the named path.