sql 7 - remote backup?

[croakyfrog]

I have been trying without success to backup a sql 7 transaction log to a remote location. i've heard sql 7 doent allow remote backups - can anyone confirm or deny this?

 

[EM1107]

You are correct. You can not backup to a remote location. The only way you can keep your backup files on a different server is to schedule a dump file copy after the backup as been successfuly completed.

This can be done using Command Exec.

 

[croakyfrog]

command exec? what is this?

 

[tlbroadbent]

You can backup to a remote server using the UNC address of the server as long as the SQL start up account is a domain user with appropriate permissions on the remote server share. Simply seet the backup location to something like the following.

\\servername\sharename\path\mydatabase.bak Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.