[RESOLVED] SQL Server Automatic Backup

Hi Guys,

Does MS SQL Server 2005 can perform automatic backup of the server (daily backup) on remote site (or other server)? Thanks in Advance.

Of course !

Open "SQL Server Management Studio", go to "Management", "Maintenance Plans"

Create a New Maintenance Plan. There you can select when you want it to execute, and you can drag & drop objects from the toolbox, just like an SSIS project (hopefully you are familiar with those)

You can also set it up to delete old backups.

Thanks, it works!