SQL Backup without server components?

• 
  There are 2 ways to use SQL Backup. One of them is via extended stored procedures, which requires you to install the server components. This installs the required extended stored procedure library, and a Windows service.
  
  The other way is to use the command line interface. To do this, you need to copy the executable (SQLBackupC.exe) to the server. If you have a license, also copy ProductActivation.exe, and run it to activate your license. The user running backups/restores via SQLBackupC.exe needs to have the SQL Server sysadmin fixed server role.

  petey February 13, 2008 00:11

  - 0 +
• 
  Ok, I'm playing with the trial version, running the GUI from my laptop. It seems I cannot pull the backup through the SQL connection to my laptop from the remote SQL server - it places the backup on the server's local drive. There is the option in the backup job to copy the backup to a network share, but that is not possible because there is no windows file share on the remote SQL server open to the internet (and god help us if we did that!) Is there no way to get a local copy of the backup via this software?

  paule123 February 13, 2008 13:08

  - 0 +
• 
  You could open a network share on your laptop, grant read/write access to the SQL Backup Agent service startup user on the SQL Server, and have the file copied to your network share upon completion of the backup.

  petey February 14, 2008 02:26

  - 0 +
• 
  I think I will just figure a way to pull the backup file via FTP. I can't expose an open Windows file share to the internet...

  paule123 February 14, 2008 13:01

  - 0 +

Add comment

Please sign in to leave a comment.