SQL Backup Maintenance Plan

Open management studio >>connect to SQL Server>>Expand Management>>Right Click Maintenance plan>>Select New Maintenance Plan Give name as you like ( FullBackupDaily) it will open designer window.Left side you can see ToolBox tab. Select Backup Database task and double click or drag and drop it to designer pane. Edit the Task for options>> connection as local,Backup…

Read More