Backup DB

[bilbonvidia]

Is it possible to backup a database to another server using a scheduled job in sql agent? I only seem to be able to back up locally to local drives. Can a unc or network drive be used? what would the script look like?

 

[ptheriault]

I just backup to local disk then add a step in the backup job to xcopy the file to the network path.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[bilbonvidia]

yep, thats what I am currently doing, So there's no native way to sql it across?

 

[mrdenny]

Yes SQL Server can backup across servers. You simply have to use the UNC path to the location.

backup database Northwind to disk='\\BackupServer\d$\folder\to\backup\location\file.ext'

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com