Activities

October 2009
M T W T F S S
« Aug   Nov »
 1234
567891011
12131415161718
19202122232425
262728293031  

Automated backup for MSSQL server 2005

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

SQLScheduler.exe

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

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>