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.
MarvmanAsked:
Who is Participating?
 
Victor SpiridonovConnect With a Mentor Commented:
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.
0
 
MarvmanAuthor Commented:
Yes the script does work
0
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.

All Courses

From novice to tech pro — start learning today.