• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

Using external scheduler to perform backups

I know that the backup scripts can be used/saved as stored procedure and executed through ISQL.  What kind of script do I need login to the database, enter user and password and perform the stored procedure.
1 Solution
Victor SpiridonovCommented:
USe the following
isql /Sserver_name  /Ulogin_name  /Ppassword /ddatabase_name /Q"EXECUTE procedure_name"

This will start isql . log into the sever server_name with login login_name and password password , go to database database_name and execute stored procedure procedure_name.
MarvmanAuthor Commented:
Yes the script does work
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now