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.