CODEWITHSUNDEEP
sqlsql-server
J Harley
J Harley

Reputation: 285

SQL Server Backup to a Remote Server

I realise there is a command: 

BACKUP DATABASE [DB Name] TO DISK [PATH]

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

Upvotes: 2

Views: 12962

Answers (2)

Joseph Ng
Joseph Ng

Reputation: 153

i created a remote full/transact backup template which you can try it out, it checks the local disk space and remote disk space before transfering.

git clone https://github.com/jnre/SQL_backupremote.git

Upvotes: 2

Thomas Rushton
Thomas Rushton

Reputation: 5826

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.

Upvotes: 8

Related Questions