![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR3eYE7skPE1gvTZcR-vN4tnQ54QNwA8kNR8ko4MLL5bJ3kneXCAX0NAf-BLZ5-I1EVW1UL0ORtZTQjciQnTcFAseqxX90qh7Umnd7534znc8I3PQ-H9MV5GwXFk6Q_nujYH-NwXdgLXc/s320/SQL.png)
Now,ceate a Schedule Task to Run the Backup Script
a) Open up Windows Task Scheduler. b) Create a new Task using the wizard, when asked to select a program browse to C:\Program Files\Microsoft SQL Server\100\Tools\binn\SQLCMD.exe
c) There are 2 arguments that need to be set:
-S \SERVER_INSTANCE_NAME -i "PATH_OF_SQLBACKUP_SCRIPT"
where SERVER_INSTANCE_NAME is the name of the instance of SQL server that contains your database e.g. (local) and PATH_OF_SQLBACKUP_SCRIPT is the path of your backup script e.g. "C:\Program Files\Microsoft SQL Server\DatastoreBackup.sql"
d) Adjust the task to run at the desired times.
via-http://srfix.blogspot.in
0 comments:
Post a Comment