Microsoft solution to automate backup on SQL Express

SQL Express

Microsoft solution to automate backup on SQL Express

NB: SQL Server Agent is not available  on this SQL release

Microsoft Solution  https://support.microsoft.com/en-us/kb/2019698

Sample Backup.cmd file

sqlcmd -U sa -P xxxx -S .\SQL2012EXPRESS -Q “EXEC sp_BackupDatabases @backupLocation = ‘C:\SQLBackups\’, @backupType = ‘F'”

You can schedule jobs with standard “Windows Jobs

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enjoy this blog? Please spread the word :)

%d bloggers like this: