In this tutorial i will show you how to configure sql server to backup database automatically. it is very simple. you need to create a maintenance plan and under that maintenance plan a sub plan for time schedule need to be configured. <br />Sql server agent must be running state all time. To ensure you may need to set automatic in service manager (default is manual)