Hello,
I have a requirement for taking daily backup SQL server 2005 express on a remote windows 2003 server. How to solve ??????
Yeah thinking and familiar with Google search will be your best friend. After the 2 hours search one of my tech-guy comes up with a solution. But I tested it through before implementing on the server.
After few months later I have need a smiler setup. Amazingly this will cause only 15 minutes to make things.
up.
Solutions
1. Download this program from http://www.lazycoding.com/downloads/SQLScheduler_LatestVersion.zip.
2. Copy the contents of the archive to a directory the target machine.
3. Run InstallService.bat file from the command prompt. The executing user account should have administrative rights on the machine. Make sure that service type is automatically started.
4. Click on
and choose the database and set the backup scheduler. Pls also configure the mail server to get the detailed status of backup process.
5. Use my ftp program to upload the backup to remote FTP as well.
-Enjoy
Leave a Reply