[SQL] FTP download and restore an MSSQL database backup
I extended my DOS batch script to restore a SQL 2000 database and grant permission to ASPNET account to pull the database backup from an FTP location.
This has been a big timesaver on a recent DotNetNuke based project. The designer and client are working off a staging server, so I regularly need to refresh my development database to keep in sync. We have a scheduled nightly database backup on our stage server that writes to a location that’s accessible via FTP, so I can just run this script and I’m caught up to the most recent backup.
CLICK HERE FOR VIEW THE SCRIPT
Sumber : Jon Galloway
