• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • 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.
0
Marvman
Asked:
Marvman
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.
0
 
MarvmanAuthor Commented:
Yes the script does work
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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