Need help to backup database on remote server using Transact SQL

Hi,

I want to backup my database using Transact-Sql Backup. Can anyone advise on this. I have tried I tried back up of my database to an Alternative Server but it fails, Why is this Query Failing ? Transact SQL query would be better to maintain. even backup to remote for now would be perfect.

Thanks

Hey,
You can use xp_cmdshell in a stored process or sql script, that will run the bcp and filecopy. if you want to backup database its not possible by running a backup command on the remote server that specifies a file that is across the network. you can use command line utility bcp to output the data to a file, and then copy the file across the wire.

You can try this http://doc.ddart.net/mssql/sql70/ba-bz.htm. This should help you to backup it up to a remote computer without any problem. Note: Backups created with Microsoft SQL Server version 7.0 cannot be restored in earlier versions of SQL Server.