Sunday, February 7, 2010

How to create schedule back up for sql server 2005 express edition

I have faced this problem from one of our small portal so I found the solution for this issue as following:


1. Using SQLCMD with Accessories -> System Tools -> Scheduled Tasks (Windows Tasks).
For example:

link

2. Using SMO Code.
For example :

Link

3.Using third Party to do the task.
For example:

Link

No comments: