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.
| Author |
Topic |
|
sqlteam_rahul
Starting Member
1 Post |
 Posted - 2005-10-17 : 00:32:03
|
| Hi friends, i want to take Db backup and save created backup(.bak) file on specified ftp site.The case is, from my ASP.NET application i will specify ftp site url and associated username/password details for ftp site. Now, i have written a stored procedure as follows: CREATE PROCEDURE spDBBackUp ( @sPath VARCHAR(2000) ) AS BACKUP DATABASE DBNameTO DISK =@sPath WITH INIT Now,i need confirmation as to can i specify ftpsite url as my i/p paramter @sPath.Will it work..?Can someone plz suggest as to what should be my methodology..? Thanks, Rahul Agrawal |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-17 : 01:02:03
|
| yes it will work only if the user calling the backup procedure have the appropriate rights to write on the location specified,for network backups, you usually should provide the logon credentials to open the locationHTH--------------------keeping it simple... |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Saving db backup file to ftp site