SQL Backup without server components?

paule123

I'm looking to schedule a daily backup of a remote SQL 2000 Server to a local SQL 2005 server. I do not have console or admin priviledges on the SQL 2000 server, so installing components on that server is not possible. Will RedGate SQL Backup work without the server components?

Seems like I can get a "good enough" backup by using SQL Compare and SQL Data Compare but that is a bit cumbersome for a simple "set it and forget it" backup.

petey

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.

paule123

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?

petey

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.

paule123

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...