Requirements - Schedule task in SQL Express Edition.
But SQL server Agent functionality is not available in express edition.
Possible Solution- Schedule batch file execution to execute sql script. Tried
cmd /k sqlcmd -i backup.sql
backup database DB_user1212 to disk = 'E:\backups\MyBackup.bak'
. But error occurred while executing sql script
A network related or instance specific error occurred while establishing a connection to SQL Server
Possible Reason- Something like connection string missing. Help me how to solve this, i am using windows authentication for connection.