Click here to Skip to main content
14,328,763 members
Rate this:
Please Sign up or sign in to vote.
Hello,

I want to create Windows Service for Download SQL SERVER Database Backup file and then Restore database in to the sql server from FTP.
Backup file will be download from FTP and then restore database automatically.

Please help me.

Thank You.
Ankit Agarwal
Posted
Comments
arindamrudra 7-Jan-13 6:14am
   
Please clarify the below things:
1. You want to download the backup file from FTP to your local system
2. Database is in the same system, where you downloaded the backup
3. Restore the database
Am I correct?

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Ankit, to download the file from the ftp please go through the below links.
1,[^] 2 [^]

To restore the back up, use the code from here[^].
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100