[RESOLVED] SQL Server Automatic Backup

[jsc0624]

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.

[CVMichael]

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.

[jsc0624]

Thanks, it works!