Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Remote_Backup_MS_SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-04-10 : 09:38:48
ajit writes "How can i take a backup of remote sql server and that .bak file suppose to save on my local machine? is there any sql code for it?"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-04-10 : 09:43:00
backup database (check BOL for syntax, use unc path)
make sure the account doing the backup has write access on your machine



just replying to the questions in the most direct manner

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -