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
Owen Slater replied
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.