Skip to Content

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

related to sql 2005 backup

sir,

we are using sql 2005 standard edition.

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

regards,

sandip

replied

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:

http://www.sql-server-performance.com/articles/dba/creating_backup_jobs_p1.aspx

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,

Owen

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