I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler.
I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a single batch file.
My environment is:
- Windows Server 2012 R2
- SQL Server 2012 Express
- Windows domain
I have gone through some related articles:
- How to schedule and automate backups of SQL Server databases in SQL Server Express
- Automated backups utilizing SQL Server and Windows Task Scheduler
- Schedule a daily backup with SQL Server Express
However, it is not clear to me how to make a stored procedure and run that stored procedure using a batch file?