Creating Backup Job in SQL Server 2005 across network

• eswar g

  Newbie

  Points: 7

  More actions

  October 21, 2009 at 4:50 am

  #212236

  Can anyboby tell the prodedure how to make a backup file for the selected database to save on to the different system. (i.e. the destination system will be in network)

• Grant Fritchey

  SSC Guru

  Points: 399206

  More actions

  October 21, 2009 at 6:26 am

  #1068798

  Just so you know, this can frequently result in slower backups that cause some visible load on the server. I prefer to backup locally and then move the file across the network.

  But... You just need to refer to the correct location by server and share name. Make sure the service that SQL Server runs under has access to it. The backup script would look something like this:

  BACKUP DATABASE X

  TO DISK = '\\myserver\myshare\x.bak'

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning