Transact SQL to backup remote database
Posted on 2007-10-11
I am wanting to write a transact SQL query to backup a remote SQL server database to a local file (database) on our server using IP address and user name and password and SQL server authentication. Can anyone advise on this. I have attempted to use wizards to copy databases in SQL management studio, and am baffled by integration services. I think a transact SQL statement would be far easier to maintain. The remote server runs SQL server 2000, and I am running 2005.