Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

related to sql 2005 backup


we are using sql 2005 standard edition.

i want make daily backup schedule so what is the procedure please help me



Former Member

Hi Sandip,

You can either use SQL Maintenance Plans to schedule a backup or you can use the SBO Backup service that is part of the server tools.

For SQL Maintenance Plans, have a look here:

For the SBO Backup service, open the SBO Service Manager, select the backup service and set the properties.

Personally, I prefer the SQL Maintenance Plan as its easy to set it up to delete older backup files and to email if the backup fails.

Kind Regards,


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question