Go Back   TechArena Community > Technology > Networking & Security
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 18-05-2009
Member
 
Join Date: May 2009
Posts: 43
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
Reply With Quote
  #2  
Old 18-05-2009
Member
 
Join Date: Apr 2008
Posts: 3,423
Re: Need help to backup database on remote server using Transact SQL

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.
Reply With Quote
  #3  
Old 18-05-2009
Member
 
Join Date: Jan 2006
Posts: 3,782
Re: Need help to backup database on remote server using Transact SQL

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.
Reply With Quote
Reply

  TechArena Community > Technology > Networking & Security
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need help to backup database on remote server using Transact SQL"
Thread Thread Starter Forum Replies Last Post
Unable to change display settings on remote Server when remote desktop to 2008 Lon Networking & Security 5 19-04-2011 10:37 PM
How to remote connections by MySQL database server Arumugan Software Development 4 13-02-2010 01:50 AM
Load SQLite database from remote SQL Server Kieran Blenkarne Software Development 3 21-11-2009 11:12 AM
How to backup the database from Apple Remote Desktop 2 OS-X-10+ Windows Software 3 16-10-2009 10:40 PM
Create cursor in SQL server via transact SQL In2TheBlues Software Development 3 10-06-2009 12:59 PM


All times are GMT +5.5. The time now is 06:08 AM.