I have a database at the client (SQL Server 2000) from which I have to put a duplicate online every night on our webserver. This is the scenario (all works well, but I need help with the final step ...)
* client sql-server: complete backup every night at 23 o'clock to 'database.bak' (vbs-script with windows scheduler)
* ftp of 'database.bak' to the webserver at 23.30 (bat-script with windows scheduler)
* webserver: delete the existing database (if necessary), restore 'database.bak' to web-sql-server, recreate user 'websqluser' at midnight
For the last step I need some kind of vbs or asp script I can call with windows scheduler. Now we have to do it by hand, but that's really no solution :-)
Any ideas ?
Thanks a lot